If you have MS Access then just export the data into Access, in two tables.
One table is all of the transaction data (100,000 rows). The other is the
values you want to keep. Inner join the two tables and the required records
will just pop out in a query. This will work a heck of a lot faster than
Excel will. If you want the VBA solution that is a whole pile more work and
will execute very slowly...

For a one time solution you could use the Vlookup function in Excel to tag
all of the keeper rows. You could sort those to the top and delete the rest
of the rows. Save the file intermittently as you work because Excel is prone
to crashing on files of this size...

HTH


"drbobsled" wrote:

Howdy:

I have 100,000+ lines of data in two sheets (Sheet1 and Sheet2)
I want to delete all Rows that have a value in Column A that matches a list
of Values in Column A of Sheet 3.
The macro could be run on each sheet individually or every sheet at once ,
except "Sheet3".

TIA

DrBobsled