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

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 want>Copy>got 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
>

Thanks! Didn't know it was so easy and trivial! Thanks very much!

Marko