Extracting the data range between two values

Hello!

In the AAA Spreadsheet, I have a range of data from which I would like to draw only the values contained in the lines between "start" and "end" and insert them into the BBB Sheet.

I have written a macro that only inserts the last found range into the BBB sheet, i.e. rows from Lp 10 to Lp 17, omitting the lines Lp 1 to Lp 7. Lpes Lp 8 and Lp 9 are empty and should be omitted when transferring data.

Attached file with an example.

Please Login or Register  to view this content.

I suspect that the problem occurs in the absence of the "Do While Loop" loop, but I do not know how to embed it.

I am asking for help, thank you in advance for any advice.

Hello Leith Ross!

Your solution works for me to

Thanks a lot!

Best regards!