If it is easier to do it in VB I will do it in VB but I am working on a macro.
I want to remove the first row, move the now second row to the third column and move to the next entry in the first row so I can continue w/ the same process. I am enclosing an example. It is possible to solve in VB or a macro?
Rows("2:2").Select
Selection.Delete Shift:=xlUp
Range("A3:B3").Select
Selection.Cut
Rows("3:3").Select
Selection.Delete Shift:=xlUp
Rows("3:3").Select
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Post Moved by Moderator.
.
I want to remove the first row, move the now second row to the third column and move to the next entry in the first row so I can continue w/ the same process. I am enclosing an example. It is possible to solve in VB or a macro?
Rows("2:2").Select
Selection.Delete Shift:=xlUp
Range("A3:B3").Select
Selection.Cut
Rows("3:3").Select
Selection.Delete Shift:=xlUp
Rows("3:3").Select
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Post Moved by Moderator.
.
Attachments
Last edited by a moderator: