JaguarSean
New Member
- Joined
- Jun 5, 2017
- Messages
- 31
Hello all
New request this morning. I've been trying all sorts of things with formula and I think I'm going to need VBA to get this task done. I've got minimal experience using VBA so I need some help. Here's what I'm trying to achieve;
I would like for a pop up window to appear and list the contents of some cells which have a FALSE statement in another column.
Column B has a large list of labels (a huge mix of text essentially but I'll keep it simple with Label 123). Column B's text doesn't have any patterns. The text can be separated by some blank cells, and sometimes not, sometimes quite a few blank cells before the next cell with text. This is the data I want to appear in the pop up box but only if column E contains a FALSE in the corresponding row.
For example;
<tbody>
</tbody>
So in the above example, the pop up window would have a message that says something like " you have differences;" followed by a list of the FALSE conditions. To add to the complexity, the data sets are in groups. I'd like to quote the group number above the label differences in BOLD, the group description has been simplified for this example but is a complex naming structure that has no pattern such as group 1, group 2 etc.
There are ~450 labels in total over ~1400 rows, 7 groups in total, again all with no pattern to how they are arranged. Followed by a final statement along the lines of "do you agree with the differences?". The above condition would display something like this:
You have differences;
GROUP 1 - Enable
LABEL 2
LABEL 3
GROUP 2 - Condition
LABEL 6
Do you Agree with the differences?
For background. I'm comparing multiple data-sets with large amounts of data and I'd like a very simple window to aid the comparison and highlight differences in the data-set. There will almost always be differences but the aim to is try and reduce those over time so the FALSE statement will change to TRUE's meaning we have a more common approach.
Any questions or thoughts?
I can provide my document if required however I'd rather not make it public info.
Many Thanks for your help
New request this morning. I've been trying all sorts of things with formula and I think I'm going to need VBA to get this task done. I've got minimal experience using VBA so I need some help. Here's what I'm trying to achieve;
I would like for a pop up window to appear and list the contents of some cells which have a FALSE statement in another column.
Column B has a large list of labels (a huge mix of text essentially but I'll keep it simple with Label 123). Column B's text doesn't have any patterns. The text can be separated by some blank cells, and sometimes not, sometimes quite a few blank cells before the next cell with text. This is the data I want to appear in the pop up box but only if column E contains a FALSE in the corresponding row.
For example;
| A | B | C | D | E |
| GROUP 1 - Enable | ||||
| LABEL 1 | TRUE | |||
| LABEL 2 | FALSE | |||
| LABEL 3 | FALSE | |||
| LABEL 4 | TRUE | |||
| GROUP 2 - Condition | ||||
| LABEL 5 | TRUE | |||
| LABEL 6 | FALSE |
<tbody>
</tbody>
So in the above example, the pop up window would have a message that says something like " you have differences;" followed by a list of the FALSE conditions. To add to the complexity, the data sets are in groups. I'd like to quote the group number above the label differences in BOLD, the group description has been simplified for this example but is a complex naming structure that has no pattern such as group 1, group 2 etc.
There are ~450 labels in total over ~1400 rows, 7 groups in total, again all with no pattern to how they are arranged. Followed by a final statement along the lines of "do you agree with the differences?". The above condition would display something like this:
You have differences;
GROUP 1 - Enable
LABEL 2
LABEL 3
GROUP 2 - Condition
LABEL 6
Do you Agree with the differences?
For background. I'm comparing multiple data-sets with large amounts of data and I'd like a very simple window to aid the comparison and highlight differences in the data-set. There will almost always be differences but the aim to is try and reduce those over time so the FALSE statement will change to TRUE's meaning we have a more common approach.
Any questions or thoughts?
I can provide my document if required however I'd rather not make it public info.
Many Thanks for your help
