Copy something to more than one sheet at once
Hi Marko
Select the first of the 30 sheets, hold the shift button down and select the
30th sheet. This will group them and the word Group will appear at the top
left of the screen.
Anything you do to one sheet, whilst grouped will be reflected in all of the
grouped sheets.
Select the complete range containing all the values you wantCopygot to
cell A1 and Paste.
Click on any individual sheet to un-group them.
Regards
Roger Govier
marko wrote:
Hi!
I have a workbook with 30 sheets and i forgot to put some formulas in
28 sheets(this is an example of my problem). Now I would like to put
the same formula(it could be text of anything else) on the same places
in those sheets(all 28 of them). How can that be done?
Thanks.
Marko
|