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...