Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Macro delete lines
Hi,
I am working on the following file in excel. A D 1 -40.07 49085 2 -13,320.00 49086 3 13,320.00 49086 4 -2,000.00 49089 5 -50.00 49091 6 50.00 49091 7 -4,154.40 49092 8 -65.00 49093 I am trying to create a macro that will delete two lines if thet have the same batch number (column D) and opposite amount in column A. For example my lines 2 and 3 should be deleted and my lines 5 and 6 should be deleted too. Thank you for your help Virginie |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Macro delete lines
As you are doing this in Excel, you would be better to post your question to
the microsoft.public.excel.programming newsgroup -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Virginie" wrote in message ups.com... Hi, I am working on the following file in excel. A D 1 -40.07 49085 2 -13,320.00 49086 3 13,320.00 49086 4 -2,000.00 49089 5 -50.00 49091 6 50.00 49091 7 -4,154.40 49092 8 -65.00 49093 I am trying to create a macro that will delete two lines if thet have the same batch number (column D) and opposite amount in column A. For example my lines 2 and 3 should be deleted and my lines 5 and 6 should be deleted too. Thank you for your help Virginie |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording a Macro to Delete A Day's Work | New Users | |||
macro button | Microsoft Word Help | |||
Macro execution using MailMerge | Mailmerge | |||
"How do I delete a Macro from the tool bar? | Microsoft Word Help | |||
How do I set up a macro to delete extra returns? | Microsoft Word Help |