Help with Auto Price Grid

[pmcdee88]

Hi Guys, i don't have a great deal of knowledge with excel apart from the basics but I'm working on an auto price grid to make my job easier and came across some great help on here with another width x drop price grid. I'm a little stumped on something and hope someone could help.

If you have a look at the attached, hopefully my explanation below will make sense.

Firstly
Is it possible when you select Type on the drop down bar in C5 eg: 'Roller Blinds' that 'Roller List', ie A-K (from cells AJ) are the available options shown in D5, and by selecting 'Louvre Blinds in C5, only picks from 'Louvre List' which shows A-G (from Cells AK) as the available options and so on for other Types.

Secondly
So far I have only managed to get the width and drop (F5 and G5) to select from one set of the width and drop (Roller Blinds) using the name manager. Is it possible that when you select type in the drop down bar of C5 that by making the blind type selection, the width and drop sizes are automatically pulled from their respective areas. As max and min widths vary from blind type to blind type, this would be crucial!

Thanks for taking the time to read :=)

[Pete_UK]

Those things are possible, but it's a bit too late here to go into them in detail. Take a look at this site:

https://www.contextures.com/exceldep...downsetup.html

where Debra gives details of dependent drop-down lists.

Hope this helps.

Pete

[pmcdee88]

Thanks Pete. From your info, I have managed to solved the First part of my issue!

[pmcdee88]

Anyone else able to help with the second part, spent hours trying to figure it out! Thanks.

[Pete_UK]

It would help if you re-submit your workbook including the changes you have made to solve the first part, as reported in Post #3.

Pete