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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!