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