Usually we just do it at the end of the month. How would I create a macro to
do it.


"Bernie Deitrick" wrote:

You could use a macro: how do you determine when a cell need to be cleared?

HTH,
Bernie
MS Excel MVP


"Metalteck" wrote in message
...
I have a spreadsheet that has at least 30 worksheets. Every month, I fill
information in certain columns. But when the new month begins, I have to
manually go back to each day and erase all the previous entries made in
that
column. Is there an esier way to do this without having to do individually
by
column?