how to populate many worksheets in a workbook
 

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

how to populate many worksheets in a workbook
 

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/



"chrisk" wrote in message
...
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

how to populate many worksheets in a workbook
 

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.
--
David Biddulph

"chrisk" wrote in message
...
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

how to populate many worksheets in a workbook
 

A simple way to do it is open eachright click on a sheet tabselect all
sheetsenter your formulaselect one sheetsave and close.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chrisk" wrote in message
...
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

how to populate many worksheets in a workbook
 

Thanks
That has saved me a lot of time :)