Extract Every Entry And Copy/Paste

[RomanGriffen]

I thought I had this done but it never worked in real time. Anyway, here is the deal.

The real sheet ALL has almost 100,000 entries and goes up to column JF not T. That being said, here is what I would like help with:

You see in sheet THIS WEEK a list of entries. I wish to compare the horses in column T THIS WEEK to the list of horses (column T) in sheet ALL. I wish to copy EVERY instance in sheet ALL of the horse listed in column T Sheet THIS WEEK and then copy/paste it to sheet Extracted.

Example: THIS WEEK has a horse in column T named Zep. The macro will read that in column T of THIS WEEK and find every instance of Zep in sheet ALL. It will then copy/paste every instance of Zep to sheet Extracted.

NOTE: the entire entry. Not to just column T. from A to column JF. Due to file size I had to severely dumb down this sheet.

please help! And thank you in advance.

[Marc L]

Try an advanced filter …