I would like to create to columns of dropdowns in and excel spreadsheet .
I want to have it so designed that ColA dropdowns determine what selections are available in ColB dropdowns.
For example A:A dropdown list include CPU,Memory,Make. If you select CPU then DropDown in the corresponding B Cell will show different CPU types. If I select Memory in a different cell in ColA then the corresponding cell in ColB will have a dropdown list of Memory Selections.
Any Ideas ?
I want to have it so designed that ColA dropdowns determine what selections are available in ColB dropdowns.
For example A:A dropdown list include CPU,Memory,Make. If you select CPU then DropDown in the corresponding B Cell will show different CPU types. If I select Memory in a different cell in ColA then the corresponding cell in ColB will have a dropdown list of Memory Selections.
Any Ideas ?