K
KARincoepm
This is my first time on this forum.. and I barely know abou
programming in excel.. I have an interesting template to be formed..
need to input data into excel with lots of dependency..
Cell in first column contains 6 fixed values from which you have t
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 fo
each selected option in column 1. Lets say its this way..
CELL 1 content-> A B C A&B A &C B & C A,
& 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 ha
customized options
If A-1 & B-3 : Then.. options available (A-1-1 till A-1-5) & (B-3-1 til
B-3-6)
And I want input box (vb script) kind of to enter the values.. suppos
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
programming in excel.. I have an interesting template to be formed..
need to input data into excel with lots of dependency..
Cell in first column contains 6 fixed values from which you have t
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 fo
each selected option in column 1. Lets say its this way..
CELL 1 content-> A B C A&B A &C B & C A,
& 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 ha
customized options
If A-1 & B-3 : Then.. options available (A-1-1 till A-1-5) & (B-3-1 til
B-3-6)
And I want input box (vb script) kind of to enter the values.. suppos
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