| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying from one worksheet to multiple worksheets
How do you copy from one cell in a worksheet to a similar cell in 25 other
worksheets in the workbook/file? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying from one worksheet to multiple worksheets
Select the range of sheets to group them.
Click in the destination cell in one of those sheets. Type an = sign. Go to your source shhet & click in the source cell. Your formula will now show something like =Sheet1!A1; hit enter to accept the formula. You can now ungroup your destination sheets by selecting just one of them. -- David Biddulph davecline wrote: How do you copy from one cell in a worksheet to a similar cell in 25 other worksheets in the workbook/file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Cell from Multiple Worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
| Copying excel worksheets to new worksheet | Excel Discussion (Misc queries) | |||
| Copying changes from one worksheet to other worksheets | Excel Worksheet Functions | |||
| Copying multiple Worksheets | Excel Discussion (Misc queries) | |||
| Copying from multiple worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
