Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MidNiteRaver
 
Posts: n/a
Default use central formula on many worksheets, central affect allsheets

i have a formula that i would like to use throughout several worksheets in my
workbook. i would like to make a single "utility" sheet where all the
formulas can be listed and then be able to use these formulas in any
worksheet in the book, rather than typing the formula each time on each
worksheet. if i change the formula in the 'utility sheet" then the formula on
all the sheets using it would have the updated formula.

I do not want the formula to refer to the cells on the "utility sheet' but
to the cells within its own sheet as though the formula was written on the
actual sheet.

thanks

Reply
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
Formula between two worksheets sheri Excel Worksheet Functions 1 July 16th 05 09:46 PM
getting a formula to find named worksheets in another? Matt D Francis Excel Worksheet Functions 5 May 20th 05 04:32 PM
Can I enter a formula using data from cells in seprate worksheets Brannon Excel Worksheet Functions 1 May 10th 05 09:27 PM
Problem with VBA returning the contents of a long formula. [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 12:14 AM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 04:16 AM


All times are GMT +1. The time now is 05:57 PM.

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"