Inserting an empty row above every highlighted row of data

Hi Guys,

I have an Excel worksheet with over 20,000 rows of data. Certain rows of data are highlighted in yellow. Each highlighted row represents the beginning of the chunk of data in the following rows until the next highlighted row. The number of rows in each chunk of data is variable.

What I need to do is to insert an empty row ABOVE each highlighted row, so that each chunk of data is separated from the one above and under it; and this will enable me for a further manipulation of each chunk of data on its own.

Can anyone give a highly appreciated assistance in this matter?

Many thanks in advance

Try this out... not sure if it will work or not

Please Login or Register  to view this content.

Sample data file attached as requested.
Many thanks

Thank you very much protonLeah for your genius code. It ran smoothly and quickly as it did exactly the required task. Always ahead protonLeah, once again thank you very much.