Select the first row where column B meets criteria

Hi,

I have a sheet that is sorted by column B. The values in that column look something like this:

FLT0618
FLT0620
FLT0625
FLT0630
FLTB201
FLTB202
FLTC201
FLTC202
FLTE201
FLTE202

What I want to do is select all the rows after the last occurrence of FLT0* and cut those rows to paste on another sheet, so in this case it would be all the rows from FLTB201 to the end. There could be a variable number of rows with FLT0*, and FLTB201 may not always be the first row, ie, we may add an FLTA201 one day.

How can VBA make this selection?

Another approach, does the copy paste for you. You had mentioned wanting to copy the entire row, so this code does.

Not sure where you want to paste, change the Sheet3 A1 values to suit your needs.

Please Login or Register  to view this content.