OK, yet another one I'm struggling to work out myself and could do with some help on!!
I have two worksheets (Sheet1 and Sheet2). Based on meeting a condition on Sheet1 AND Sheet2, I'd like to use macros to automatically hide rows on Sheet2.
Sheet1 sample:
<tbody>
</tbody>
Sheet2 sample:
<tbody>
</tbody>
The conditions are:
If on Sheet1, a Type has the Selection "Include", then any rows on Sheet2 which have that same Type are shown (ie. not hidden).
If on Sheet1, a Type has the Selection "Exclude",then any rows on Sheet2 which have that same Type are hidden.
So in the example tables above, if ONLY Type A = Include, then on Sheet2, the rows for Sample URL1 and Sample URL2 are shown, and the others are hidden.
Also in the example tables above, if Type A = Include AND Type B = Include (and all other Types are Exclude), then on Sheet2, the rows for Sample URL1, Sample URL2 AND Sample URL3 are shown, and the others are hidden.
I'm fine with the concept of If... And... on the same worksheet, it's trying to get it to look at two separate worksheets I'm struggling with!!
I'm hoping this explanation of what I'm trying to do makes sense! Not sure how to attach a sample XLS on here...
Thanks in advance!!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have two worksheets (Sheet1 and Sheet2). Based on meeting a condition on Sheet1 AND Sheet2, I'd like to use macros to automatically hide rows on Sheet2.
Sheet1 sample:
Type | Selection |
A | Include |
B | Exclude |
C | Exclude |
D | Exclude |
E | Exclude |
<tbody>
</tbody>
Sheet2 sample:
Link | Type |
Sample URL1 | A |
Sample URL2 | A |
Sample URL3 | B |
Sample URL4 | C |
Sample URL5 | C |
Sample URL6 | D |
Sample URL7 | D |
Sample URL8 | E |
Sample URL9 | E |
Sample URL10 | E |
<tbody>
</tbody>
The conditions are:
If on Sheet1, a Type has the Selection "Include", then any rows on Sheet2 which have that same Type are shown (ie. not hidden).
If on Sheet1, a Type has the Selection "Exclude",then any rows on Sheet2 which have that same Type are hidden.
So in the example tables above, if ONLY Type A = Include, then on Sheet2, the rows for Sample URL1 and Sample URL2 are shown, and the others are hidden.
Also in the example tables above, if Type A = Include AND Type B = Include (and all other Types are Exclude), then on Sheet2, the rows for Sample URL1, Sample URL2 AND Sample URL3 are shown, and the others are hidden.
I'm fine with the concept of If... And... on the same worksheet, it's trying to get it to look at two separate worksheets I'm struggling with!!
I'm hoping this explanation of what I'm trying to do makes sense! Not sure how to attach a sample XLS on here...
Thanks in advance!!