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.