View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve G Steve G is offline
external usenet poster
 
Posts: 44
Default Using Named Formulas

On Aug 17, 11:39 am, General Specific wrote:
I have a worksheet with daily sheets calculating daily labor charges.
These are named to correspond with the days of the week (Monday,
Tuesday, Etc...).

These daily sheets use the same formulas to calculate labor charges.
I would like to name the standard formulas and call them by name in
each sheet. I did that for the Monday so instead of calculating hours
I have =Daily_Hours.

When I put =Daily_Hours in the Tuesday sheet, it still refers to the
Monday form.

How do I create generic named formulas that I can use in all the daily
sheets?


Possibly this works--I would put the formula in a cell by itself. You
could make the cell a range name. Then you could reference that cell
or range name in all of your other cells that involve the formula.

Steve G