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.
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.