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