Populating Coloums attached to Dependent Lists

[Mooseman60]

Can anyone help me with this

I current have a spreadsheet i am constructing for quoting, it has 2 drop down list
First List is Coloum B on Quote form =Categories second Coloum C on Quote form =Product Description, Coluoum D =Quantity, Coloum E =Unit, Coloum F =Price, Coloum G =Material Total, H =Labour, Coloum I = Total Labour, Coloum J = Line Total, Coloum K =Calculated Estimated Hours.

At present if I select Roofing from the Category list box when i click on the Product list box I have a choise of 3 different materials. If i select one of these 3 selections this shows up in the product coloum. What I want to happen then is the unit to show up in Coloum E, the price in Coloum F and the Labour in Coloum H but i dont seem to be able to make it work

I have attached my spreadsheet

Thanks

[DonkeyOte]

Your named ranges would imply you need to use a construct along the lines of:

Please Login or Register  to view this content.

[Mooseman60]

Thanks very much thats awsome Cheers

[Mooseman60]

Thanks very much thats saved me a lot of hair Cheers