Copying from one worksheet to multiple worksheets

D

davecline

How do you copy from one cell in a worksheet to a similar cell in 25 other
worksheets in the workbook/file?
 
D

David Biddulph

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.
 
Top