Insert new rows as per the delimits

**Yuvaraaj** · 01-03-2016, 05:17 AM

If column "A" contains data with delimiters " | " then it should check column "B" and if column "B" is blank. Macro should run by inserting new rows to the count of delimiters " | " present in column " A" and should copy data from column G to column K.

Before and After screen shot, excel attached.

Please help!!

**mike7952** · 01-03-2016, 06:23 AM

Heres one way

Please Login or Register  to view this content.

**Yuvaraaj** · 01-03-2016, 07:15 AM

@ Mike Half satisfied with your prompt response but every new line inserted need to copy the data's present from column G to column K.
You can see in the output file an example.
Looking forward your response.

**mike7952** · 01-03-2016, 10:57 PM

Give this a try

Please Login or Register  to view this content.

**Yuvaraaj** · 01-03-2016, 11:23 PM

Thanks Mike

It is perfect now but need to check with large data's.
Marked the report as solved.

Insert new rows as per the delimits

LinkBack

Thread Tools

Rate This Thread

Display

Insert new rows as per the delimits

Re: Insert new rows as per the delimits

Re: Insert new rows as per the delimits

Re: Insert new rows as per the delimits

Re: Insert new rows as per the delimits

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Insert Rows on Criteria and Copy content to Specific Cells in New Rows(Tables)

[SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet

Insert header , hide rows and insert page breaks

Insert header , hide rows and insert page breaks

Insert new row & prompt to ask how many rows to insert

[SOLVED] VBA insert/delete rows to accommodate exact number of rows from incoming data

[SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions