see attached workbook - please use attached workbook...
Hi Experts
Need a extra step being add to the current macro in module 1. fro macro button update data fields inworksheet "sheet1"..
...
I am in the process of creating a workbook for the user to be able to complete multiple functions all based round a main table containing customer and shipping details. This will all be run fr...
Hi
I have format one or more ranges as a table in Excel 2007. Using the code below from the macro recorder I can see that it is simple to add one table format which is automatically named ...
Hello experts -
I need to calculate -in EXCEL - the dates of each Wednesday in November 2008
ie 11/5, 11/12, 11/19, 11/26.
Hopefully this can translate to other months also.
Can you p...
Hi there,
I have a workbook attached that has the wrong decimal place values and would like them to be corrected please so that they return the correct value decimal places.
Can I have excel look at a cell, determine the value of that cell, determine if it falls within a range of values, then store that indication, look at the next cell, do the same thing again, f...
Hello,
I have a spreadhseet with listings of all 50 states and its
populations and than I have a 2nd sheet that has each of these states
listed but seperated by 6 rows. What I would lik...
I'm not receiving error messages, I just need to be able to have a macro automatically remove one right space from a manufacturer part number, manufacturer, or description. I am currently doi...
I have two separate pieces of code that will not work in the same subroutine. Let me clarify that... whichever code is first in the subroutine works...
Below are the two peices of code:
The ...
I have an Excel file in which cell C2, is protected by a drop down list validation. When the value of the drop down list changes, all the values in the excel sheet change. I want to use a macr...
How can I stop Excel from filtering the bottom row of data when using AutoFilter? I'm using Excel 2007, and I know I could make the selection into a table, but I do not want to use a table in...
Hi All
Im using Excel 2007. I am a bit red faced asking this question. A lot of experts have tried to help me with questions on making loops run faster. I eventually figured out the real pro...
I need a formula in A2 that will replace the last space in A1 with ", Ste ".
Thanks!
John
I have an Excel spreadsheet containing a number of worksheets.
Since the worksheet names run beyong the right-hand side of the monitor, i right-click the mouse once on
the scroll buttons a...
It has been about 3 years since I did any code development in VBA and I am stumped on a linear simualtion problem.
I have a product that is inserted into a series of processes and it remain...
How to add some extra space before the number when exporting to a txt file from Excel?
I saved this worksheet as a csv file as shown below.
How can I make the number column to be fixed l...
Hello,
I don't know how to make this formula in Excel. Example if B1 has a text or a number (as long as it's not blank), then I want "YES" to appear in A1, if B1 is blank, then "No" sho...
I need to create a list of all files (and their file sizes) in five directories and then email them using either WORD or EXCEL. An example output could be:
To: Mr. Danito
Subject: Notice o...
I am very frustrated by Excel XP's design where you lose your clipboard as soon as you make a change in your document. In other words, I copy some cells, type in text in a different worksheet...
Is it possible by not using code to change the default font type of a comment box from that different to the general set up font type?
How can I make Excel do do this for me.
I have the following text:
0035,229050708073528073621000041587
And I need excel to give me the consecutive, I mean
0035,2290507080735280736210000415...
Hello,
Thank you very much in advance for your help!!! I have a spreadsheet with a bunch of cells that have data in them. Each individual cell has data spread out in the cell with carriage ...
I have imported data that has immbeded tabs in the Text Cell, and I need to Remove them.
Hello Experts!
This question is related to the following discussion:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23814866.html
A custome...
I have a workbook that has a summary sheet "SUMMARY", and numerous data sheets that are labelled in order, RR0001, RR0002, RR0003...all the way to RR0367. From each of these sheets, I want to...
