Hello,  I have a workbook that has 3 pages representing data from 3 US
Regions: Central, Western, and Eastern.  Each page has a named range for the
data: data_Central, data_Western, & data_Eastern).  I would like to pivot the
data, but I need the pages combined.  Is there a way ...

I joined your group after searching the archives for help and could not
find anything.  I have an Excel spread sheet that is 15 columns and 148
rows.  Cells G18:G36, I18:I36 and G54:G60 have a blue border around
them.

I want to set my worksheet that will always be open on my machine to
automatically refresh the data at 12am. Is the only way to do that with
a macro? If so, how do I go about that. Thanks!

=IF(ISBLANK(C6),"0",IF(($C6-$A$4)<=14,"Current",IF(($C6-$A$4)<14,$C6-$A$4)))
I have the above formula.  I need the first <=14 to evaluate th
difference in dates.  if the  date is between 0 and 14 days, it mus
say current, if it is anything other than that, or blank, it must show

I am trying to determine the appropriate equation for my application
I have the following:
=IF($D2="C-D",RANK($F2,(IF($D$2:$D$106="C-D",IF(ISNUMBER($F$2:$F$106),$F$2:$F$106))),0),NA())
What I want to do is Rank the values in F2:F106 if the values in D2:D106 =

Good afternoon,
I have a situation where the content of a cell is based on what the active
cell is. This is to display a Help message. I know i could use the Data >
Validation > Message but this is not a good use for what we are trying to

I'd like to have the ability to enter a description within a calculation
instead of entering the description in an adjacent cell. Something like:
=(4.08+2.5)[Acres] would yeild a result of 6.58 Acres.
----------------

I am making a master pricing worksheet catalog. I am purchasing the same
products from mulitple vendors, all use the same product code as well. I have
set up 3 different vendors to compare prices on items. How do i put a formula
together on my master worksheet to scan these other ...

I work with chemical formulas which include subscript formatting i.e.
H2O (the 2 should be subscript. Even here I can't get the subscript to
follow with copy/paste). I work in Excel 2003
I want to pull from one table to another , but I need it to pull the

I have five rows of data, representing five weeks of information.
I would like to delete the oldest info (week 5), and move the other
weeks up.
And then enter the new info for week  Any help appreciated.

Using Excel 2003, I want to click-and-drag-fill a lookup formula through a
column, changing the lookup value with each row, which happens automatically,
but referring to a fixed lookup table (in another sheet). I either have to
copy without autofill, and then go in and manually ...

need formula for validating data in a cell. function required is for allowing
only multiples of 10

How do I split the state and the city into 2 column?
ie
column A  ...............like to see in column B as State............Column
C as City    

I wish to back up my xls files to dvd. I keep getting "You do not have access
to folder 'E:\'. See your administrator for access to this folder."
I am using XP and Office 2003.
Thanks, mickey

Is there a way in Excel to use the Min function to determine the minimum
  value in a column, and copy that entire row to a new area of the
spreadsheet?
For example,