Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cant not change history on a shared workbook | Excel Discussion (Misc queries) | |||
Excel Should Have a History Function. | Excel Worksheet Functions | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) |