Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
Clear History
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear History | New Users to Excel | |||
cant not change history on a shared workbook | Excel Discussion (Misc queries) | |||
Auto clear when qualification is met | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions |