I want to use the result in a cell to complete the worksheet name part of a
formula, so that the worksheet name can be a variable.
eg. ='sheet2'!A4
but the sheet name needs to be able to change depending on what is in cell

What if I have two lists in two files each with about 59000 rows but with the
same structures. Multiple Consolidation only seems to allow me to summarize
on one key. I need the resulting pivot to summarize by sales, product group,
and period number. If only I could have more rows ...

I am wanting to format cells so that automatically recognize the data being
inserted and change the font color.  i.e. completed would become green, not
completed would become red.

I know how to print a dynamic file name in a footer but that doesn't solve my
issue.  I can't find an option to print footers just at the end of a file.  I
can't find a function like the date/time where you can insert a dynamic file
name in a cell.

Recently I've noticed when I go to the windows tab to change between
spreadsheets, Excel has added a second copy of a particular spreadsheet and
annotated it with a 1 or a 2. Has anybody else seen this occur? Spreadsheet
names: MRW952thru993.xls:1 and MRW952thru993.xls:2 There ...

I am looking to use the and command along with SumIf command to check
the conditions of two columns. If the two columns are true sum up the
columns that are true.
Example: SumIf(And(C7:C400="",G7:G400>1 then sum D7:D400)

I have used Access "Tools" to analyze a query with Exel but can't get Exel to
then total a field without reentering all the numbers in the field.  If this
makes any sense to anyone, please help me figure out how to make it work.  
Thank you.

There's an article here:
http://office.microsoft.com/en-gb/assistance/HA012260381033.aspx
It explains exactly what I'm trying to do almost, I want to transpose this
array (from the article close to the bottom):

I have a workbook in which Sheet1 contains a list of unique enquiry
numbers in column E, and a name in column C.
Sheet 2 also contains the same data - Name in column A; enquiry number
in column B and a third column C with a numeric value in it (time spent

Hey how would I change the font/cell color with a formula, example
=IF(B6="green", fontcolor=green, fontcolor=red
--
exutabl

I have a series of calculations that I need to use the MIN formula. the
problem is that many of the cells can have a 0(zero) value and not just
blank. Is there a way to find the minimum value but ignore the 0's? Otherwise
the minimum is always 0.

I was working on a spreadsheet that took me 7 hrs & I saved it by pressing
the save disc on the toolbar...I thought i emailed it to myself but instead I
emailed a blank & when I opened the email to view it the next day it the
download mgr said you already have a file with this ...

In my file i am having formulae (about 52 columns), while copying the formula
the calculating cells take huge time. How to improve the speed?
Vennilla.

Hi,
How could I check if the cell in a column starts with a certain alphabet, if
yes, then in a different columns cell add the word "DONE"
eg: validate column P, if a cell starts with XYZ, then in coulmn B, of the

I found something I would like for my workbook. I found it on MVP Debra
Dalgleish's page http://www.contextures.com/xlDataVal03.html. The original
code is from Peo Sojblom and it's about hiding previously used items in a
drop down box. I have my list of dealers on a sheet ...