Hi all, I'm new to the forums here and could appreciate any bit of help I can get for my filtration issue.
What I'm trying to do is apply a temporary filter from a range varying from 15-30 cells to a list of 2,000+ cells and copy over the supplementary data from my criteria. The Data should match verbatim to one another, both ranges are in table format, I included the top row of the table as per the prompt, and there are a few different filters by value set up within either workbook.
I encounter my problem when applying the filter using the 'Advanced Filter' under the sort and filter ribbon of the data tab. What happens is my list range shrinks to nothing or I get a value that is completely irrelevant.
See below for step-by-step pictures:
http://imgur.com/EtB7vr8
http://imgur.com/8cHKfKa
http://imgur.com/VKHI6QV
http://imgur.com/hhQVAlC
Thanks so much in advance.
Bookmarks