Macro to shiftevery row in a worksheet below one row

[vasanthr]

Hi All,


I have an workshet wherein there are several hundreds of rows with certain values . I need a macor to shift all the rows below one row and modify the first row with my new data. I dont want to insert a new row at the top since it modifies my graphs and charts.

Eg :

Row 1 : A B C D E
Row 2 : 1 2 3 4 5
Row 3 : S T U V W
Row 4 : 5 6 7 8 9

After i execute the macro it shoudl be

Row 1 : A B C D E
Row 2 : A B C D E
Row 3 : 1 2 3 4 5
Row 4 : S T U V W
Row 5 : 5 6 7 8 9

I know it can be easily achieved through insert new row. But i dont want to insert but just modify the data by copy paste entire row to new one

Please help me to acheve it through a macro.

Thanks
Vasanth

[JBeaucaire]

So, copy the entire used range of data, and paste down one row?

Please Login or Register  to view this content.