Copy from sheet one to several sheets

[lmagne]

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)

 

[Roger Govier]

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