I have a workbook with 5 sheets and a total sheet for those 5 other sheets
titled "Access". We have about 20 other workbooks that this total sheet needs
to be transferred over to to run totals. When we try to copy and paste the
total sheet into the 20 other workbooks, the total ...

i need to create a formula that requires me to divide a total by the average
total, subtract 1 from the result before formatting as a percentage

I'm trying to format a field in a PivotTable row.  When I right-click and
choose Field Settings, I don't see the NUMBERS button (usually located
underneath the LAYOUT button).  Why is this happening?  I have Excel 2003,
SP2.

I need to be able to loop though column a & if a condition is true, I
need to caculate a sum in based on the value in column m..
I need to be able to display the count of the active cell & the sum of
column m &

I am a teacher trying to make a list of parents who work in my room every
Tuesday.  How can I make a date list that includes every Tuesday through the
end of the school year?
Thanks! Lisa

I am trying to set up a template so that I can just click on a cell and an
"X" will appear.  Can this be done in Excel?

I am using (=IF(10=MONTH(N16),CELL("contents",H23),H13)) at this time to have
data moved to a cell on different month. But sometimes when the month changes
I loss my data and get N/A. Is there a function that will let me send the
value to the cell automatic as the {manual Paste ...

I have created a macro to give me start and finish times with the click of a
button,
Function my_now()
Application.Volatile (False)

I have a list of 20 names in Column A of my spread sheet.  Then I have 13  
columns which represent  13 weeks (1/4 of a year).  Each week there are 6
people assigned to be moderators and I place the letter M in 6 different rows
within the column for the specific week.   I also put ...

Is there a way to change the sheet name in a formula with a name that
is stored in a cell?
I have a vlookup that looks in sheet1 range. I have in the Cell a10 the
name of the sheet I want to lookup the value.

I have different conditions in a cell.
If the cell value is either "awarded", "launched" or "high" the cell should
have green pattern.
If the cell value is "medium" the pattern should be yellow.

I am looking for a formula that allows the spreadsheet to look in a range of
weights, selects the proper weight range and returns the corresponding rate
associated w/ that weight break.  Not sure I can do it justice w/out an
example.

I hope this is as easy I thyink it might be. Is there a way to have the name
of an individual worksheet appear in one of the cells in the same sheet?
Thanks.

The Excel Function Dictionary is back on a web site.
www.xlfdic.com
It's still free. (Its still the same!)
Thanks to all who still fly the flag for the old file.

I have a problem for creating appointment schedule.  For example,with a given
date No 1, say 24 Nov 06. The criteria is  I cannot make appointment 5
working days before 24 Nov06 and 2 workdays after.
A2 = (date before); B2 = (Given Date No. 1); C3 = (Date after Given)