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

Doug
Tue Dec 12 12:27:44 CST 2006

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" <vtalmard@gmail.com> wrote in message
news:1165942893.280187.258850@79g2000cws.googlegroups.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
>