how to populate many worksheets in a workbook

[chrisk]

how to populate many worksheets in a workbook.
I have a 15 workbooks with 30 sheets each and i want the same formula in the
same cell in all 450 sheets.
eg =counta(d9:d5000,"*") in cell aa2 in each work sheet.
I don't mind putting it in 15 times but hopefully not 450 times

Thanks

 

[Damon Longworth]

You will have to do this in each file. Select the first sheet - scroll to
the last sheet. With the SHIFT key pressed, select the last sheet. Now all
sheets will be grouped. Add you formula to the active sheet and it will be
added to all selected sheets.

Right click on a sheet tab and ungroup.

--

Damon Longworth

2008 US East Coast Excel / Access User Conference
Atlantic City, New Jersey - Sept 24-26, 2008
www.ExcelUserConference.com/



how to populate many worksheets in a workbook.
I have a 15 workbooks with 30 sheets each and i want the same formula in the
same cell in all 450 sheets.
eg =counta(d9:d5000,"*") in cell aa2 in each work sheet.
I don't mind putting it in 15 times but hopefully not 450 times

Thanks

 

[David Biddulph]

To select multiple sheets, click on the tab for the first one, then
Shift_click on the tab for the last one, then you can do what you want in a
cell on one and it will do it on all the sheets you've selected. Remember to
click on the tab for one sheet afterwards to ungroup them for further edits.

If the sheets are not contiguous, use Control-click, not Shift-click.

That will deal with the 30 seeets in one book, but I don't know of a way of
doing it on multiple books.

 

[Don Guillett]

A simple way to do it is open each>right click on a sheet tab>select all
sheets>enter your formula>select one sheet>save and close.

Of course, you can use a macro to open each>then a for each loop for each
worksheet.

 

[chrisk]

Thanks
That has saved me a lot of time