how to populate many worksheets in a workbook

  • Thread starter Thread starter chrisk
  • Start date Start date
C

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
 
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
 
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.
 
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.
 
Back
Top