A macro would do the trick. Try posting on the Excel Programming board and
maybe someone there will post some code for you.

"dk" wrote:

we have a spreadsheet that has columns for customer charges and totaling the
charges from all columns and have a paid column for partial or full payment
and then having a balance column we would like to clear old history
Is there anyway to clear every 2 months automatically all rows that paid and
only keep unpaid info? or is there any other prog. that links to excel and
works better