Excel Macro Help Insert Row

[Closed]
Report
-
Posts
5
Registration date
Sunday March 15, 2009
Status
Member
Last seen
May 9, 2009
-
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 reply

Posts
5
Registration date
Sunday March 15, 2009
Status
Member
Last seen
May 9, 2009
1
hi,
try this link to see if it can help you to solve our problem:
http://dmcritchie.mvps.org/excel/insrtrow.htm
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month