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