insering empty row based on a condition

Using macro, I want to add an empty row above every content in column A

For e.g. if cell A2 has a content in it, then add an empty row above it.
Likewise, if cell A4 has no content in it, then no need to add an empty row above it.

Take a look at the image below
Untitled.jpg

I have attached a sample workbook, it contains,
Sheet 1, the data before running the macro
Sheet 2, shows after the data looks like after running the macro
Sheet 3, contains a button where the macro should be inserted
row.xls

Hi,

One way

Please Login or Register  to view this content.

HTH

Try this

Please Login or Register  to view this content.

Hope this helps