I have a Master Worksheet with historical data that I do all of my reporting
and charting from. It is rows of various data by create date with a unique
record identifier (Ticket Number). Each weekday, I get a new list of records
in and Update Worksheet with the past 7 days of records using MSQuery through
ODBC to external data. Some of the records repeat and others of them are new.
I would like to append only the NEW unique records (based on Ticket Number)
from the Update Worksheet into the Master Worksheet.

This what I tried and got stuck on --
The Master data is sorted so I can do a vlookup on the new record set. If
the record is new, I set the flag to 0, else 1. I created a macro to
autofilter for 0. In my macro, I selected Cell A1. I moved the cursor down 1
to eliminate the header row and then selected all the filtered data. This
would work fine if the first filtered row was always row 2 but as it turns
out, the macro recorded Row 54 as the first filtered row under the header
row. Unfortunately, this will not always be the case.

Can you please help me automate this task?