Hi,

To create a dependent list based on a previous selection, please check the
solution at the following link

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

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Luke22" wrote in message
...
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