Fast Solution to Problem: 4th or some 5th drop down list on excel 2007

4th or some 5th drop down list on excel 2007

Hi
I have a MainCategories, SubCategories, 2nd tier SubCategories, Item which I like to use the drop down lists to show the end result.
If MainCategories is selected, the related SubCategories will show up the list.
If SubCategories is selected, the related 2nd tier Subcategories (2SubCategories) list will show up, but not all the SubCategories has the 2SubCategories.
For example, lets say has 5 SubCategories, only 2 out of the 5 SubCategories has 3SubCategories,
MainCategories: Camera
SubCategories: Tripod, Camera, Accessories, Battery and Charger, Camera Bags
2SubCategories:  only Accessories and Battery and Charger has 2SubCategories list.
(Batter and Charger selected)
3SubCategories: Battery, Charger, Batter Cases.

Item List.
the rest of 3 SubCategories will show up the Item List straight away.
MainCategories: Camera
SubCategories: Tripod, Camera, Accessories, Battery and Charger, Camera Bags (Camera Bags selected)
2SubCategories:  only Accessories and Battery and Charger has 2SubCategories list.
So if Camera Bag selected, it show up Camera Bag Items directly.
Item List.
(Camera Bag Items)
How can I make this to work?
And the reason I make this is to put them into the quotation form for sales to pick up the products to avoid typo.
However if I use the dependent drop down list, how can I make the sales to pick up the one of the final ITEM LIST,
and then it show up only Item No.
and Item Description/Name on the form
Item No | Item Name
but not include
MainCategories | SubCategories | 2ndSubCategories | 3rdSubCategories | Item      or
MainCategories | SubCategories | 2ndSubCategories | Item 
which take up lots of extra column spaces.

I'm not familiar with excel, has spend couple days google and practice, but get stock with partial 2SubCategories, and has no idea how to make the end result to show up only Item No and Item Name.
It will be highly appreciated if the Excel Experts can show
me the way steps by steps.

Thanks in advance.

Anwsers to the Problem 4th or some 5th drop down list on excel 2007

Download Error Fixer for Free Now

Use the System File Checker tool to repair corrupted or missing system files:

1. Click Start.
2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
4. Type or copy paste the below command line into it without quotes:
5. "Sfc /scannow"

Recommended Method to Repair the Problem: 4th or some 5th drop down list on excel 2007:

How to Fix 4th or some 5th drop down list on excel 2007 with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed

Related:
Read More: Fast Solution to Error: 2011 windows live messenger yüklenmiyor,How to Fix Error - 64-bit Publisher 2010 - Publisher failed to start correctly last time.?,How to Fix Error - 404 not found error and 403 forbidden messages for everything i search?,2007 Access table moved to sharepoint 2005 became read only. how to fix? [Anwsered],Troubleshooting:2 problems with Vista and mail on new laptop Error,2 minute hang at "Welcome" screen, but only on Admin account.,2 failed updates: KB970892 error code FF, KB978338 error code 800B0100,2003 excel keeps freezing and even crashes when email is active,3D Studio Max side by side configuration error,404 not found nginx message