Spreadsheet Questions
 

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?

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?

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?

Metalteck,

Sorry, I should have worded my question more precisely.

What criteria determine if a cell should be cleared? Do you clear all rows
higher than row #, or columns I & J when column B is a number? Or.....

If you are always clearing the same cells on each sheet, then you could
simply turn on the macro recorder prior to starting to clear your cells,
perform the clear, then turn off the macro recorder.

If you have variable cell amounts that you clear, you could turn on the
recorder, clear the maximum number of cells rather than just those needing
to be cleared, and that should account for the variability.

HTH,
Bernie
MS Excel MVP


"Metalteck" wrote in message
...
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?

I'd just do one 'month end' clearing of the cells, then save that worksheet
as the template for a new month.. that way you're not backfitting an older
worksheet each month..

"Bernie Deitrick" wrote:

Metalteck,

Sorry, I should have worded my question more precisely.

What criteria determine if a cell should be cleared? Do you clear all rows
higher than row #, or columns I & J when column B is a number? Or.....

If you are always clearing the same cells on each sheet, then you could
simply turn on the macro recorder prior to starting to clear your cells,
perform the clear, then turn off the macro recorder.

If you have variable cell amounts that you clear, you could turn on the
recorder, clear the maximum number of cells rather than just those needing
to be cleared, and that should account for the variability.

HTH,
Bernie
MS Excel MVP


"Metalteck" wrote in message
...
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?