insert two empty rows below used data

**johncena** · 06-30-2010, 11:44 AM

Please Login or Register  to view this content.

dear friends i have found above macro from net & it's inserting empty rows base on column "A" data change,my data starting in column "A" row 2 to down.i want to insert column "A" data available all rows below two empty rows.pls help me to do that....

**Leith Ross** · 06-30-2010, 01:36 PM

Hello johncena,

Can you give us an example of how the data should look before and then how it should look after the macro is run?

**johncena** · 07-01-2010, 12:12 AM

Originally Posted by Leith Ross

Hello johncena,

Can you give us an example of how the data should look before and then how it should look after the macro is run?

thanks for your reply friend.here i have attached my sheet.first sheet is my normal data & second sheet is i expected data.

**Leith Ross** · 07-01-2010, 02:27 AM

Hello johncena,

I have add the macro below to the attached workbook. There is a button above "Date" in column 1 to run the macro.

Please Login or Register  to view this content.

**johncena** · 07-01-2010, 05:49 AM

thanks a lot Leith Ross.it's work very well.REP+

insert two empty rows below used data

LinkBack

Thread Tools

Rate This Thread

Display

insert two empty rows below used data

Re: insert two empty rows below used data

Re: insert two empty rows below used data

Re: insert two empty rows below used data

Re: insert two empty rows below used data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions