I would like to use a cell reference    A1 = Jan-03  to look up
worksheet named "Jan-03" in another workbook.   Is this possible?
TIA
Jill

Has anyone encountered Formula's that stop working in
Excel 2000?  Recently I've had several users state that
all of a sudden, their formula's stop working.  I
uninstalled and reinstalled Office 2000 Pro on one users

I need to use the sub total function in a way so that the
rows showing sub total are on a sepeprate sheet rather
than on the same sheet as the data.
eg.

I have a workbook with about 60 worksheets and a summary
sheet. The summary sheet contains totals of a specific
cell in each of the 60 sheets. One way to do is the long
way by typing the whole formula. But is there any better

How can add median and percentrank to the field settings in a pivot table?

Hi, am looking for a key stroke to use within a workbook
that will get me to the next sheet.  please email me
directly with this info at mpittman@conn-selmer.com
thanks

For Excel users the character map is found way way out in the back 40 i
Start/Programs/Accessories/System Tools/Character Map. Once there I ca
choose a symbol then copy and paste to my worksheet. There must be a
easier way to grab a fraction or other symbol that doesn't have

I am trying to create a drop down box that feeds from another drop dow
box ... is this possible?  For example, if I select "Yellow" in on
drop down box, I want the second drop down box to only contain certai
values such as "Sun" and "Flowers".  If "Blue" was selected from th

I need help with multiple criterias in Excel. From earlier messages in
this group I have understood that I should use SUMPRODUCT but I can't
get it to work properly. Excel just gives me the output #VALUE!. (I
use Excel 2000.)

I have a curvilinear function in an Excel spreadsheet.  I would like Excel
to calculate the definite integral for me.  Does anyone have any advice on
how I can develop or find add-in functions to do this?
Thanks.

I want to print a column of dates that only print the date
for each Saturday of each week, but at the end of the month
I need the last date of each month printed. The problem
that I'm have is getting the first Saturday of each month

I have a excel spreadsheet calculating yield of an investment.
I am using function "YIELD", in which there are 4 items : sold date
sold price, bought date and purchased price.
the last two items are fixed, won't change.

Is it possible to apply the =PROPER command to the entire worksheet.  I have a .CSV file I would like to fix prior to importing back into my other program.

What formula will change the color of text depending on
the value of another cell.
Example if A1 is >0, text for A2 = Blue
          A1 is <0, text for A2 = Red

I have 3 columns of data - A,B,C.
Column A has my Product Group Info (eg. Product Group A,
B,C,D...Z)
I would like to filter my spreadsheet to show me rows that