Thread
:
Advanced Filter/Extracting Data
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Advanced Filter/Extracting Data
If Account names are in leftmost column (not necessarily A), use VLOOKUP
HTH
--
AP
"jayrthomas" a écrit dans le message
de news:
...
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
Reply With Quote