Copy from sheet one to several sheets
 

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)

Copy from sheet one to several sheets
 

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


lmagne wrote:
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)