![]() |
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? |
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