Multiple Dependant Drop Down Lists

I sorted the categories in order so that they were easier to deal with and I discovered that the number of categories is 31 and there are only 30 categories with products. I added a dummy listing for the missing category which is highlighted in the listing.

All illegal characters for the naming of cell ranges were eliminated so the category listing looks different. Spaces were replaced with _ and / with\ and there were others also.

Hope this helps

Thanks for your reply, both methods seem to work. Only thing I have to do now is work out how to stop the cost column from showing #REF! and add a total at the bottom that adds up the cost column.

Thanks for everyones help with this.

Regards
Stewart