Populate cells with info from other tabs, based on whts picked in a drop down SOLVED

Ok, I have this spread sheet for figuring out total costs of shirts. I have a pulldown that contains all of the shirt types, the shirt types also have their own tabs that contain prices for sizes and quantities. I want to populate cells in the main tab (the tab with the pulldown) with the prices from the shirt type tab, based on the selection of the pulldown. The cells to populate would be the ones shaded blue.

I have no clue how to make this happen. I dont even know where to begin, any help would be greatly appreciated.

OK, try this:

Please Login or Register  to view this content.

A different approach might be this.

Instead of a combo with all products, use a dynamic named range in G5 For manufactures product, this in turn controls a dynamic dropdown in G6 displaying the related range of syles for the selection in G5.

This might make the product selection easier if the range becomes large.

The related prices are then called by formulae in D12:H14
Typically

Please Login or Register  to view this content.

Hope this helps

Your last question might be better in a new thread.

First mark this thread solved if you are happy with the outcome.

Then in your new thread describe your new problem and post the workbook you have adopted and the one you want to link to.

This way you will get a better response to your problem.

I'll keep an eye open for it.