Excel Macro Help Insert Row [Closed]

Question

Excel Macro Help Insert Row [Closed]

Report

Someonenice - Mar 26, 2009 at 12:29 PM
ange.lina10

Posts: 5
Registration date: Sunday March 15, 2009
Status: Member
Last seen: May 9, 2009

- Mar 27, 2009 at 04:59 AM

Hello,

I need help with a macro for excel that will look at my sheet and if theirs data in Colomns D2:Z20.
If theres data in any of the columns after C2 I would like it to create a new row below the existing row and move the data thats in the column to a new row. Sorry my english not so good.

Here is example:

A   B    C               D            E                          G
1
2 GL 10100	SomeData GREENLAND	HOLSTEINSBORG
3 GL	10101	SomeData	GREENLAND

Since their is Data in the Cell D2, E2, and G2 I would like to insert a new row below D2 (move everything down) and then move the E2 data and G2 (Cut and Paste) to the new inserted row that I just created it would be D3 and D4.  Columns A B and C can remain blank. I just need to take the data that's after Dcolumn and put it on a new row below the existing one.

Excel Macro Help Insert Row
Excel macro to insert rows between data - Forum - Excel
Excel macro to insert rows - How-To - Excel
Excel Macro to insert row based on data ✓ - Forum - Excel
Excel macro to insert row and copy formula ✓ - Forum - Excel
Code for macro that conditionally inserts rows ✓ - Forum - Excel

1 reply

Ask a question

ange.lina10 · Accepted Answer · 2009-03-27T04:59:57-0400

Answer 1 / 1

ange.lina10

Posts: 5
Registration date: Sunday March 15, 2009
Status: Member
Last seen: May 9, 2009

1
Mar 27, 2009 at 04:59 AM

hi,
try this link to see if it can help you to solve our problem:
http://dmcritchie.mvps.org/excel/insrtrow.htm

Excel Macro Help Insert Row [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!