Hi!

Im trying to set up an excel spread sheet with some drop down tabs. I want
to be able to select a certain "item" from the drop down tab which will then
auto fill other cells to give me certain figures.

This table is for costing and ordering hardware for cabinets. If i select a
certain cabinet, i want the next cell to then have a drop down list of the
sizes available in that cabinet, which then gives me a price in the next cell
for that cabinet and its size. Also then i want the number of certain items
needed for that cabinet to auto fill in the cells after that.

So i should be able to select the cabinet, then a size that cabinet is
avialable in. Then look at the price and what hardware is needed for that
cabinet

If this has been covered somewhere please point me in the right direction!

Thanks
Luke