How do I hyperlink a value so it will show the value on another sh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a budget with several different sheets. The first sheet is an
overview of the budget. What I want to do is link the balance of each sheet
to the budget overview sheet so that the remaining balance value will show on
the overview sheet. Now is this possible? I have hyperlinked them but that
won't allow the value to change on the overview sheet, also I tried
referenceing the cell but Excel won't allow me to reference another cell on
another sheet. I'm not very experienced with Excel so I'm just trying to
experiment here. Any help would be appreciated.
 
To reference a cell in another sheet, state the sheet name followed by the
cell address:

=Sheet2!A1
 
Back
Top