Reefslayer
IS-IT--Management
Hello all,
Been trying a few things and quickly got out of my depth.
I'm trying to use Excel as a configurator for a network management application I support.
I have a worksheet which contains a series of questions.
E.G. Switch manufacturer. Switch model Etc.
Initially i tried to marry these questions to answers via designating a cell as data validation and referencing the cells which could provide the possible answers.
I'm now at the next level whereby I want the sheet to take the response to Q1 e.g. manufacturer and then present a list of options in the list for the "model" Q2 following on. i.e. If I chose Cisco for manufacturer then for the model I only want a list of Cisco models (These too are listed in the sheet and could be selected)Along with
How would i Facilitate this. Is it possible within the confines of standard Excel or would i need some code?
Either way could anyone offer any pointers?
Any help greatly appreciated.
Many thanks.
Been trying a few things and quickly got out of my depth.
I'm trying to use Excel as a configurator for a network management application I support.
I have a worksheet which contains a series of questions.
E.G. Switch manufacturer. Switch model Etc.
Initially i tried to marry these questions to answers via designating a cell as data validation and referencing the cells which could provide the possible answers.
I'm now at the next level whereby I want the sheet to take the response to Q1 e.g. manufacturer and then present a list of options in the list for the "model" Q2 following on. i.e. If I chose Cisco for manufacturer then for the model I only want a list of Cisco models (These too are listed in the sheet and could be selected)Along with
How would i Facilitate this. Is it possible within the confines of standard Excel or would i need some code?
Either way could anyone offer any pointers?
Any help greatly appreciated.
Many thanks.
