#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dk
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear History dk New Users to Excel 1 April 27th 06 04:45 PM
cant not change history on a shared workbook cyndi Excel Discussion (Misc queries) 0 December 15th 05 09:14 PM
Auto clear when qualification is met Paul987 Excel Discussion (Misc queries) 1 October 10th 05 01:53 PM
Can't Clear Print Area GeorgeF Excel Discussion (Misc queries) 2 August 5th 05 06:10 PM
Using a Macro to clear out check box seletions Mel Excel Worksheet Functions 5 May 20th 05 08:35 PM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"