Filtering a price list using an auto filter??

  • Thread starter Thread starter Emily Steed
  • Start date Start date
E

Emily Steed

Need to filter a manufacturer's price book so my spreadsheet only shows
those items which I normally carry.
Price book has 5,000 items. I carry about 150 of those items. In my
spreadsheet, I put the following:
Column A are the manufacturer's product numbers. Columns B through E
have product description, weight, cost, retail price, etc. I put my
inventory product numbers in Column G.
Question, how do I use Autofilter to filter my spreadsheet such that the
spreadsheet only shows those items I carry? In other words, how do I
use my inventory product numbers in Column G to filter the
manufacturer's price book?

TIA for your help.
 
Hi Emily

Select columns A:E
Select "Data>Filter>Advanced Filter"
In the dialog box:-
Under "Action" select "Copy to another location"
Under "List Range" enter (or select) A1:E5000
Under "Criteria Range" enter (or select) G1:G150 making sure that the
heading in G1 is the same as in A1
In the "Copy To box enter (or select) I1
Select "OK"

--
XL2002
Regards

William

(e-mail address removed)

| Need to filter a manufacturer's price book so my spreadsheet only shows
| those items which I normally carry.
| Price book has 5,000 items. I carry about 150 of those items. In my
| spreadsheet, I put the following:
| Column A are the manufacturer's product numbers. Columns B through E
| have product description, weight, cost, retail price, etc. I put my
| inventory product numbers in Column G.
| Question, how do I use Autofilter to filter my spreadsheet such that the
| spreadsheet only shows those items I carry? In other words, how do I
| use my inventory product numbers in Column G to filter the
| manufacturer's price book?
|
| TIA for your help.
|
| --
| Emily Steed
| Please post your response to NG, thanks.
 
Select a cell in the list
Choose Data>Filter>AutoFilter
From the heading in column G, choose (Nonblanks)
 
Back
Top