macro to add empty rows before and after specific rows

**wfm** · 12-01-2014, 06:33 AM

hello,
I am new to this forum and need "some" help. I am not a very experienced Excel user but need to convert a lot of files from Excel tot a SQL database. Thefore I need to insert rows in exsisting Excel files otherwise the rest of the conversion will not work.
There must be 1 row inserted before and after every row that contains an "Underline" mark up.
I think it is dificult to explain wat I need but maybe the two files that I attached make it clear.
File version 1 is the state of the file before and version 2 is the result I need.
Normaly the files can contain thousands of rows.

I hope you can help me.

Thanks in advance,

With kind regards.

Fred

version 1.xlsm version 2.xlsm

**Greg M** · 12-01-2014, 12:34 PM

Hi there,

Take a look at the attached workbook and see if it does what you need. It contains the following code:

Please Login or Register  to view this content.

The value of the constant used to indicate the data column can be altered to suit any change in the layout of your worksheet.

When performing operations like this it is important to ensure that the variables you're using to track your progress through the data rows remain accurate even while new rows are being inserted. For this reason the scan process begins at the bottom of the data column and progresses upwards towards the top - any new rows are inserted below the row currently being checked, so the row tracker always remains accurate.

Hope this helps - please let me know how you get on.

Regards,

Greg M

P.S. My compliments on the clear way in which you explained your requirements - it made finding a solution that much easier