I want to take the horse (Column T) from sheet 'This week', match it to horses in column T in sheet 'All' and then paste every instance/match from sheet 'ALL' into 'Extracted.'
Note: this list is huge. There are over 30,000 entries in sheet 'ALL'. Usually in sheet 'ThisWeek' there is a thousand.
the code below does what I need it to other than two things.
1. It does not past the entire row. I need it to go all the way up to and including column JF.
2. It does not paste every instance of the horse (Column T) in sheet 'This Week' from sheet 'All'.
3. I know I said two. But... I don't want it to resize the columns.
Bookmarks