Excel Macro Help Insert Row

Closed
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.

1 response

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
1