Clear History
 

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

Clear History
 

Lots of ways.
datafilterautofilter
macro that looks to see if current and deletes paid
etc


--
Don Guillett
SalesAid Software

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