Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Question Unanswered: Link a table to another table?

    Greetings-

    I have to link a table to another table. I created a detailed budget, using three sheets. Sadly, when I add another expense, I have to update it in all three sheets, when it would be awesome to just have a master. I'm using Excel 2007.

  2. #2
    Join Date
    May 2009
    Posts
    258
    In order to achieve this, you will want to use a formula in the individual sheets that references the expense cell(s) in sheet1.

    The formula in the individual sheets would be something like this:
    Code:
    =sheet1!A2
    Replace sheet1 with the reference sheet name and "A2" with the cell reference that you want to be applied to the other sheets.

    Regards,

    Ax

Posting Permissions

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