Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ChrisSeattle
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 01:02 AM
FILTER OUT DATES IN LIST Lisa Excel Worksheet Functions 1 January 31st 05 03:17 PM
Which function(s)? LB Excel Worksheet Functions 3 January 5th 05 07:19 PM
looking to update price list, wanted to up charge list by 35% . frankie Excel Worksheet Functions 2 December 13th 04 03:17 PM
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . Dan W Excel Worksheet Functions 0 December 1st 04 04:53 PM


All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"