RAKESH230583
New Member
- Joined
- Jan 10, 2011
- Messages
- 46
Hello All,
I am preparing one tracker, attached below for clear understanding - The table on left is what the user needs to fill in -
1) They need to click on the required check box from column A
2) Moment they select the check box from column A, the Sequence in column B will be auto-update.
3) Data in column C is the Default data that will be available, for their selection.
4) Column D - This is what Users need to fill in by typing manually after selecting the check box from Column A.
Expectation :
Cell highlighted in column F, To show the consolidated view based on the selection from table"Feedback".
Currently, I am doing it with the help of multiple formulas like - Concatenate, if , ISnumber, char(10) - which helps to update the feedback list in real-time. However, wanted to see if this can be possible via VBA?
I am preparing one tracker, attached below for clear understanding - The table on left is what the user needs to fill in -
1) They need to click on the required check box from column A
2) Moment they select the check box from column A, the Sequence in column B will be auto-update.
3) Data in column C is the Default data that will be available, for their selection.
4) Column D - This is what Users need to fill in by typing manually after selecting the check box from Column A.
Expectation :
Cell highlighted in column F, To show the consolidated view based on the selection from table"Feedback".
Currently, I am doing it with the help of multiple formulas like - Concatenate, if , ISnumber, char(10) - which helps to update the feedback list in real-time. However, wanted to see if this can be possible via VBA?
