I am looking to create a loop that will look specific text in column A. Once found, it will look for the first cell above that cell, that contains another specific text. There maybe any number of rows between the 2 cells, and there can be several occurrences of these through column A
So for example, say cell A1 contains text 'A'. Cell C1 contains text 'B'. The loop first looks for 'B', and once found then looks for 'A' in a cell above it. I then need to use the number of rows between the 2 to resize a range