Hello Everyone.
I wasn't reading those newsgroups for a few years.
Time flies.

I hope someone can help me.

I have data extracted through ODBC to 2 sheets.
Sheet "01" contains all purchase order lines in the last two years. About
30,000 records.
Sheet "MD", (Multiple delivery), contains about 3,000 records.
All fields on 01 are in MD, but MD sheet has a few additional fields in the
middle.

I copy the whole sheet MD to 'Report' sheet, since I need all delivery
details, and have to add remaining records from 01 sheet, excluding already
existing purchase order lines on MD.
I used on 01 sheet Index / Match formula to mark in the column on the right
records that already exist on MD and then can use filter to copy and paste
remaining records but I would like Purchasing Supervisor to 'press a button'
and have this done automatically.

I have problem with two steps. One is with selecting the range
automatically, the other is Do Until loop. I have never created macro that
does looping at all.
I can see those two being really useful for us, since we have a lot of table
structured data imported through ODBC.

Could someone help, please.

Thank you in advance.
Wes