Advanced Filter/Extracting Data

[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

[Barb Reinhardt]

You could use VLOOKUP to get the info you want.

"jayrthomas" wrote:

> 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

[Ardus Petus]

If Account names are in leftmost column (not necessarily A), use VLOOKUP

HTH
--
AP

"jayrthomas" <[email protected]> a écrit dans le message
de news: [email protected]...
> 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

[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.

jayrthomas wrote:
> 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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html