Copy from sheet one to several sheets

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

Guest

I am making a timelist for a firm in growth, i have made 52 copies(sheets)
how can i get the cell E4 on sheet1 to copy itselves to E4 on the next 51
sheet? To make it easy for new emloyers)
 
Hi

Click on the tab for Sheet2, hold down Shift and click on the tab for
Sheet52. This will Group the sheets.
Now, in cell E4 enter
=Sheet1!E4
Click back on tab for Sheet 1 to ungroup.

Anything you do to sheets when in Group mode is replicated through the other
sheets.

Regards

Roger Govier
 
Back
Top