Duplicating rows with data from same row

May 20, 2011 at 13:09:25
Specs: Windows XP
I need for the information in each cell of my sheet from Column M on to be duplicated as a new row within the sheet in Column L of the new row. All Data prior column L should be the same as the originating row.

so the below sheet-

A B C D E F G H I J K L M N O
1 1 2 3 4 5 6 7 8 9 1 2 3 x y z
2 2 3 4 5 6 7 8 9 1 2 3 4 c
3 3 4 5 6 7 8 9 1 2 3 4 5 a b

Would be converted to-

A B C D E F G H I J K L M N O
1 1 2 3 4 5 6 7 8 9 1 2 3
2 1 2 3 4 5 6 7 8 9 1 2 x
3 1 2 3 4 5 6 7 8 9 1 2 y
4 1 2 3 4 5 6 7 8 9 1 2 z
5 2 3 4 5 6 7 8 9 1 2 3 4
6 2 3 4 5 6 7 8 9 1 2 3 c
7 3 4 5 6 7 8 9 1 2 3 4 5
8 3 4 5 6 7 8 9 1 2 3 4 a
9 3 4 5 6 7 8 9 1 2 3 4 b

Thanks in advance


See More: Duplicating rows with data from same row

Report •


#1
May 20, 2011 at 13:11:12
The data did not post correctly the numbers should all be shifted on position to the left to resemble an actual excel sheet...aplogies

Report •

#2
May 20, 2011 at 16:16:27
Click on the following line and then edit your post after reading the instructions found at that link.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question