neodjandre
Well-known Member
- Joined
- Nov 29, 2006
- Messages
- 950
- Office Version
- 2019
- Platform
- Windows
I have column C with the following structure:
[blank]
item1.1
item1.2
item1.3
BA1
[blank]
item2.1
item2.2
BA2
[blank]
item3.1
item3.2
item3.3
BA3
[blank]
and so on...
I am looking for a macro that finds let's say "BA2" and then adds all items above "BA2" (until a blank cell is reached) to a dynamic array. In this example the array will have item2.1 and item2.2
Not sure how to go about this, any help would be much appreciated.
Andrew
[blank]
item1.1
item1.2
item1.3
BA1
[blank]
item2.1
item2.2
BA2
[blank]
item3.1
item3.2
item3.3
BA3
[blank]
and so on...
I am looking for a macro that finds let's say "BA2" and then adds all items above "BA2" (until a blank cell is reached) to a dynamic array. In this example the array will have item2.1 and item2.2
Not sure how to go about this, any help would be much appreciated.
Andrew