| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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) |
|
#2
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
| Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
