View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
General Specific General Specific is offline
external usenet poster
 
Posts: 12
Default Using Named Formulas

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?