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, quot;Account Name.quot;
Thanks
If Account names are in leftmost column (not necessarily A), use VLOOKUP
HTH
--
AP
quot;jayrthomasquot; gt; a écrit dans le message
de news: ...
gt; If I have a master list of 800 accounts and a smaller list of 200
gt; accounts,
gt; how would I go about extracting the data from Spreadsheet A to Spreadsheet
gt; B
gt; for just those 200 accounts? Spreadsheet A containing detailed account
gt; information, Spreadsheet B containing just Account Names. Both
gt; spreadsheets
gt; with a common field, quot;Account Name.quot;
gt;
gt; Thanks
You could use VLOOKUP to get the info you want.
quot;jayrthomasquot; wrote:
gt; If I have a master list of 800 accounts and a smaller list of 200 accounts,
gt; how would I go about extracting the data from Spreadsheet A to Spreadsheet B
gt; for just those 200 accounts? Spreadsheet A containing detailed account
gt; information, Spreadsheet B containing just Account Names. Both spreadsheets
gt; with a common field, quot;Account Name.quot;
gt;
gt; Thanks
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:
gt; If I have a master list of 800 accounts and a smaller list of 200 accounts,
gt; how would I go about extracting the data from Spreadsheet A to Spreadsheet B
gt; for just those 200 accounts? Spreadsheet A containing detailed account
gt; information, Spreadsheet B containing just Account Names. Both spreadsheets
gt; with a common field, quot;Account Name.quot;
gt;
gt; Thanks--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
- Jun 04 Wed 2008 20:44
Advanced Filter/Extracting Data
close
全站熱搜
留言列表
發表留言