Need help from an excel master

[uhcord98]

This is complicated, I will try to explain this in the best way possible.

Sheet 1
I'm going to have one sheet that has PRODUCT CODES in one column along with NUMBER SOLD in the column right next to it.

Sheet 2
I want to count all PRODUCT CODES from sheet 1 and place them into categories. For example, 1 category on sheet two might contain 1-X amount of PRODUCT CODES from sheet 1. So I take it some type of lookup command that can count multiple values needs to be used??

Sheet 3
I want a drop down list that shows all categories and when a category is selected I want it to display the total amount sold in the cell next to it...

Any ideas?? I know this is a tough one...lemme know if it makes sense.

[mudraker]

uhcord98

Welcome to excelforum

Please read forume rules - see links below

Your thread title is invalid as per the rules

[lalbatros]

Without understanding precisely your objective, I guess that you might enjoy pivot tables. Read about that.
Also, your question looks close to a small database application. In MS-Access (or other db like sqlserver) you could do such things very easily and you could link a pivot table to the database to report in Excel.