Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search, using lists maybe?
What I have:
An order form with multiple SKU's and 6 columns for the customer to place over a 6 month period and then another 6 columns showing history for same period last year. A simply version of it would look like this: Customer Number: 12345 July Aug Sep Oct Nov Dec His Ord His Ord His Ord His Ord His Ord His Ord SKU-A 3 4 SKU-B SKU-C 1 4 SKU-D 3 8 SKU-E I also have a report (exported to excel) showing sales by product for each customer on a different sheet. Now to have a single report for each customer would take far to much time (4000+ customers) so I have all the history data in a single report. What I would like to do it somehow create a search, so when you enter a customer number on Sheet1 (order form), it will sort the data on Sheet2 (history). That way, i will be able to use a vlookup to pull the history into the order form. Is something like this possible? I would be grateful for any help you guys n gals could provide. Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Setting up and Configuration of Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |