Prev: FORMAT FOR FEET AN DINCHES
Next: Refernce other files and auto update info
From: davecline on 13 Jan 2010 12:33
How do you copy from one cell in a worksheet to a similar cell in 25 other
worksheets in the workbook/file?
From: "David Biddulph" groups [at] on 13 Jan 2010 12:45
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?


 | 
Pages: 1
Prev: FORMAT FOR FEET AN DINCHES
Next: Refernce other files and auto update info