Excel automatically calculates cells which I don't need so I went to
Tools > Options > Calculations and changed it to manual calculation.
But from time to time for some reason, Excel switches back to automatic
calculation. Is there any reason for this and anyway I can avoid this

This group helped me out a bit before and I'm hoping you can now as I'm
almost done.  I'm trying to calculate an annual commission that is paid out
quarterly based on year to date performance.  Basically if Jan/Feb/March
sales are grater than 50,000 but less than 100,000 then 1/4 ...

I have a bunch of invoices in a folder and need to get a total on how much I
made.  Can i set up a formula that will import cell d34 from every file in
the folder I specify and give me a total?

i need to generate these letters
aa ab ac....ax ay az....ba bb bc....zx zy zz ? down the A column
What's best/easiest way?

This formula looks at a cell and replaces the full date with jst the month
and the year....but some cells are blank, in this case this formula sends
back "100"
I need to add something to this formula that when the cell is

Is there a function I can use in Excel 2002 that returns the page number on
which a particular cell (or line) occupies?  I have entries on each page
identified A, B, C etc, and I want to append a suffix to the letter to
indicate which page it is on (A1, B1... A2 etc).

i have in column A there are companies
in column B there are values
in column C there are periods
i want to find the relative position of each company (RANK) referred to

I need to save a file 2 times the first time for production, the second time
as a backup, I want the backup file to have a date stamp (ex.
gltransfer051506.csv).
i need the date to update each day it run.???

I have 20 workbooks and the main worksheet in each has the same layout.  I
need to consolidate the inforamtion provided in these workbooks into a single
worksheet.
The data hosted in these files consist of text and numbers.  

I currently have a set of data which is all in upper-case text
characters.
Before I can merge the data with another column I need it so that the
first letter of each cell is in upper-case and the rest is in

Hi all, hope somone can help!
I wish to create a spreadsheet whereby the 'summary' sheet contains a
dropdown box list, say months of the year, and on selecting a month in the
list the summary sheet would then display data from another so-named

I am having data which is entered by different person's say a,b,c,d & e in
different sheets (a,b,c,d & e). I want to combine all this data into one
sheet called Combine.
Whereas the columns are same in the five person's sheet say (x,y,z). Do you

I would be grateful if someone could offer their advice on how to solv
a problem I am having with XL.
I am trying to sum all the values in column C if column A and Column
meet the correct criteria.

I wonder if it's possible to use vlookup or some such function to call
and copy cells from a table.
I have a table such as:
product   color   units   weight    retails    discount    total cost

Hi there everyone,
I have some data which has been output from our database into Excel.
The data takes the form of Company name, address, website, e-mail et
(all in separate columns).