karincoepm
New member
- Joined
- Apr 3, 2013
- Messages
- 4
- Reaction score
- 0
- Points
- 0
This is my first time on this forum.. and I barely know about programming in excel.. I have an interesting template to be formed.. I need to input data into excel with lots of dependency..
Cell in first column contains 6 fixed values from which you have to choose.. lets say those are A,B,C, (A&B), (A &C), (B & C), (A,B & C)
Cell in second column depends on this and has customized options for each selected option in column 1. Lets say its this way..
Cell in column 3 depends on these choices filled in column 2 and has customized options
If A-1 & B-3 : Then.. options available (A-1-1 till A-1-5) & (B-3-1 till B-3-6)
And I want input box (vb script) kind of to enter the values.. suppose in case I want take input for 2 categories in the same cell like A-1 & B-1, I need to have both drop down options inputs in same input box.
Cell in first column contains 6 fixed values from which you have to choose.. lets say those are A,B,C, (A&B), (A &C), (B & C), (A,B & C)
Cell in second column depends on this and has customized options for each selected option in column 1. Lets say its this way..
CELL 1 content-> | A | B | C | A&B | A &C | B & C | A,B & C |
CELL 2 Options -> | | | | | | | |
| 1 | 1 | 1 | A-1 & B-1 | A-1 & B-1 | A-3 & B-2 | A-2 & B-2 |
| 3 | 2 | 2 | A-1 & B-3 | A-2 & B-3 | … | A-3 & B-1 |
| 1&3 | 3 | 3 | ….. | …. | .. | …. |
| | 1 & 2 | 1 & 2 | …. | …. | …. | …. |
| | 1 & 3 | 1 & 3 | …. | …. | …. | ….. |
| | 2 & 3 | 2 & 3 | … | …. | … | ….. |
| | 1, 2 & 3 | 1, 2 & 3 | … | …. | … | ….. |
Cell in column 3 depends on these choices filled in column 2 and has customized options
If A-1 & B-3 : Then.. options available (A-1-1 till A-1-5) & (B-3-1 till B-3-6)
And I want input box (vb script) kind of to enter the values.. suppose in case I want take input for 2 categories in the same cell like A-1 & B-1, I need to have both drop down options inputs in same input box.