Summarising data using combo box

Hello,

I reeealy need help

I have about 44 sheets of data which show information about different products from manufacturers (1 sheet=one manufacturer). Every sheet has the same number of columns (the same info about the every product), but different number of rows (one manufacturer has more products to offer than the other one). I wish to make a summary sheet, where by using the combo box (from which you would pick a manufacturer), the data about that manufacturer would be shown. Is this even possible?

Thanx a lot in advance!

P.S. I have attached an example with just 3 sheets

Your requirement is quite vague..... I would suggest posting a sample of your workbook demonstrating how you want the summary sheet to look (what data you want summarised and where it should go)

Hi,

Welcome to the forum.

Do you need to have them all in separate tabs? If they all have same columns, generally I'd recommend having them all in one sheet with the first column having the Manufacturer in it. You could then set up your data as table or add an auto-filter so you can just choose the manufacturer from the drop-down. The benefit is generally your data is more maintainable in the long run and it's simpler to add a new manufacturer.

I don't know what external needs you have to meet with this, so it may not be appropriate to your situation.

The attached example is just an illustration. The first column is where you'd filter for Manufacturer.

S

Ihave just seen Maistryes post. I agree entirely. All in one page add auto filters or pivot table voila.... easy to manage, re, your point about ease for user , write some guidance steps......

I am still unclear as to what data you want to pull, you say "full analysis"....in your last post and "summary" in your first post...... but what is it that you want to see? that the Audi R8 is petrol???

Have you thought about using a pivot table?

ok, see attached, All data in one sheet,,,,,,,, a pivot table demonstrating the answer to your question.

Ohhhhhhh. homework! you have to learn rather than have someone do it for you! I would recommend this site.

http://www.contextures.com/xldataval02.html

Everything you need to know to complete your assignment in the prescribed way is in this link

Good luck

Do you have a sample of his style?

@ Maistrye - i imagine it's something like this, see attached