Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Product Price List with 14k records, filter w/out using AutoFilter
Is there a way to customize a filter, similar to auto filter, but allowing a
user to enter their search criteria in a cell at the top of the worksheet. Example: In Cell B2, enter modular and have the worksheet then filtered showing only those records with modular within the record. This is being used by a number of sales associates who lookup items they need to price for proposals. The worksheet contains 14,000 + records, with column headings of Mfg, Part Number, Description, U/M, Cost, Price A, Price B and Price C. -- Respectfully, Chris H Seattle, WA |
#2
|
|||
|
|||
You could use an Advanced Filter. To learn more, see:
http://www.contextures.com/xladvfilter01.html Also look at the section about wildcards. HTH Jason Atlanta, GA -----Original Message----- Is there a way to customize a filter, similar to auto filter, but allowing a user to enter their search criteria in a cell at the top of the worksheet. Example: In Cell B2, enter modular and have the worksheet then filtered showing only those records with modular within the record. This is being used by a number of sales associates who lookup items they need to price for proposals. The worksheet contains 14,000 + records, with column headings of Mfg, Part Number, Description, U/M, Cost, Price A, Price B and Price C. -- Respectfully, Chris H Seattle, WA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
FILTER OUT DATES IN LIST | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions | |||
looking to update price list, wanted to up charge list by 35% . | Excel Worksheet Functions | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions |