hello guys, i have an older thread link below with 2 questions.

http://www.excelforum.com/excel-form...o-pages-3.html

I have a workbook based on computer components. There is a sheet titled "options" which breaks down 4 different options with lists of components. Then there are individual sheets titled by their component. When going through each component sheet i can place the letters "E,P,R,M" in any cell (no letter more than once) and it will take that corresponding item and place it in the option sheet based on the letter choice. E= Elite, P= Premier, R = Recommend, and M = Minimum. It works off the formula in columns G,N,U,AB.

Question 1
Now i would like to create a new sheet titled "Upgrades". What i want to achieve is basically the same theory as in the options sheet. This time i want to place the letter U in a separate column in each component sheet and have that specific component appear on the "upgrades sheet".

Example: In the sheet titled "Cases" I want column E to represent upgrades. There are 25 different options in the cases sheet. I'd like to pick up to say, 3-5 as upgrades. I place the letter "U" next to any of the items in column E and that name + price + MU + customer price + rebate appear on the "UPGRADE" sheet. I may have as many as 5 different upgrade choices all with the letter "U". Is that possible?

Question 2
After the "UPGRADES" sheet is established i want to create a third sheet. Call it "sheet 3" for now. Here i will have a page in which a customer can pick and choose upgrades from a drop down list, but some of those upgrades will be dependent on previous choices.

Example: Let's say i give a customer the option to upgrade their CPU of their computer with 3 choices; choice 1, choice 2, choice 3. I also provide the customer the option to increase the RAM of their computer with choice A, and choice B. If and only If the customer chooses to upgrade their CPU will they be able to upgrade the RAM and to further complicate it (sorry!!) only Choice 2 and Choice 3 of the CPU will allow the customer to upgrade the RAM to choice A or Choice B.

CPU Choice 1 - No RAM choices
CPU Choice 2 - RAM Choice A
CPU Choice 3 - RAM Choice A, Ram Choice B

I hope that isn't too confusing. JETE has experience with my threads, hope to hear from you!! If anyone else has a suggestion or answer i'd love to hear it, please refer to the previous thread post #34 for the workbook. Thanks to anyone who helps!!