RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hello.
I'd like to add an indeterminate amount of strings to an array, and then use that array as filter criteria on another sheet.
In order to find what to add to the array, I would be looking at the left(6) of column 1, and then the string on column 29 needs to be added.
Here's an example:
So if my current row was on DONKEY, I would see that left(6) would result in finding A1, A3, A4 and A6. So I want to add them to an array, then autofilter a range ("A1:BD" & LastrowDF) on field 56 with the CriteriaArray("A1", "A3" etc)
Is this possible? Can you add things to an array piece by piece? Cheers.
I'd like to add an indeterminate amount of strings to an array, and then use that array as filter criteria on another sheet.
In order to find what to add to the array, I would be looking at the left(6) of column 1, and then the string on column 29 needs to be added.
Here's an example:
Column 1 | Column 29 | Added? |
DONKEY | A1 | Y |
DONKEY-F | A3 | Y |
DONKEY-F | A4 | Y |
DONKEY-F | A6 | Y |
BADGER | A5 | N |
BADGER-F | A2 | N |
So if my current row was on DONKEY, I would see that left(6) would result in finding A1, A3, A4 and A6. So I want to add them to an array, then autofilter a range ("A1:BD" & LastrowDF) on field 56 with the CriteriaArray("A1", "A3" etc)
Is this possible? Can you add things to an array piece by piece? Cheers.