Can I link a cell in several worksheets to a master worksheet?

  • Thread starter Thread starter BigBuck98
  • Start date Start date
B

BigBuck98

Is there a way to link a cell in several worksheets (Sheet#1, Sheet#2,
Sheet#3) to a (Master) worksheet, so that when ever an amount in a
particular cell in one or all of the Sheets is entered it will add that
amount to the Master worksheet?
Thanks,
Gordon
 
Hi Gordon

if you're looking for say cell A1 on the Master sheet to sum the values
entered into cell A1 on the other sheets, then yes it is possible,
reorder your sheets so that the master is either the first or last and then
click in cell A1 on the master sheet and type an
=sum(
then click on the tab for the first sheet that you want to include then
hold down the shift key and click on the last sheet you want to include
then
click on cell A1 and press Enter

copy / repeat / fill for other fields as desired.

Hope this helps
Cheers
JulieD
 
On the master sheet in the cell you need to link -- if you want to sum the cells
and the cells on the corresponding sheets are not the identical cell location,
enter + and navigate to the 1st sheet cell location and click, then enter + and
navigate to the second sheet cell location and click, etc etc until you have
captured all the cells necessarryu


: Is there a way to link a cell in several worksheets (Sheet#1, Sheet#2,
: Sheet#3) to a (Master) worksheet, so that when ever an amount in a
: particular cell in one or all of the Sheets is entered it will add that
: amount to the Master worksheet?
: Thanks,
: Gordon
:
:
 
Back
Top