| 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 | |||
Linear Mode
