LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Limit To Number Of Named Formulas? [email protected] Excel Discussion (Misc queries) 3 July 14th 07 07:14 AM
running totals, named formulas Memento Excel Worksheet Functions 1 May 8th 07 09:35 AM
Finding Named Field in Formulas Jeff Jones Excel Worksheet Functions 2 April 28th 07 01:22 PM
Using Named Formulas in Charts DCSwearingen Excel Discussion (Misc queries) 1 July 20th 06 09:27 PM
How to find all formulas that used a certain named range Laurence Lombard Excel Discussion (Misc queries) 2 October 25th 05 08:15 AM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"