ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying from one worksheet to multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/253247-copying-one-worksheet-multiple-worksheets.html)

davecline

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?

David Biddulph[_2_]

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?





All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com