Advanced Filter/Extracting Data

J

jayrthomas

If I have a master list of 800 accounts and a smaller list of 200 accounts,
how would I go about extracting the data from Spreadsheet A to Spreadsheet B
for just those 200 accounts? Spreadsheet A containing detailed account
information, Spreadsheet B containing just Account Names. Both spreadsheets
with a common field, "Account Name."

Thanks
 
D

Debra Dalgleish

Start the Advanced Filter on Sheet B
Reference the master list as the List range.
For the Criteria range, select the small list, including the heading.
Select a cell on Sheet B as the Copy to range.
 
Top