+ Reply to Thread
Results 1 to 3 of 3

Referencing a formula

  1. #1
    Registered User
    Join Date
    08-18-2005
    Posts
    3

    Question Referencing a formula

    I am having problems working out how to reference an entire formula from another cell so that it doesnít just bring in the calculated value.

    e.g. I want it so that when I make a change to one formula it will update the formulas in all the other workbooks, without me having to copy and paste it

    Thanks

  2. #2
    Dave O
    Guest

    Re: Referencing a formula

    How about the OFFSET() function, using cell references in the
    arguments?


  3. #3
    Registered User
    Join Date
    08-18-2005
    Posts
    3
    Hi,

    Not too sure if this will do what I require, apologies I probably didnít explain myself well.

    What im aiming to create is a master sheet with all my formulas on.

    I then will set up separate workbooks which will pull in the formulas from the master sheet and not just the values. e.g. pull in =G$5+Input!A4 and not just the answer e.g. 5. (input relates to a worksheet containing lookup tables)

    This will mean if I need to amend the formula to say A5 instead of A4 I can just update the formula in one place saving me having to copy and paste the new formula into each spreadsheet.

    (To be honest im not even too sure if thats possible in excel.)
    Last edited by Sprout; 08-22-2005 at 08:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1