Formulas won't delete cells on their own. You have several options. You
could use AutoFilter to find the cells of interest and delete them that way,
or you could use VBA to do it. If you want a VBA solution, it would help if
you were more specific in what what you want to delete and from where.

HTH,
Barb Reinhardt

"Jman" wrote:

i have a worksheet with about 30 spreadsheets. In every spreadsheet i have
cells that i want to delete automatically (the cells contain different
numbers in table formats). Can i have a formula that automatically deletes
only the cells i specify from every spreadsheet..

I want to do the automatic deletion so i can save the sheet with the
selected deleted cells and start a new one. "similarly how a template works."