I wanted to do the following actions with the help of macro.
1. Delete column B to T and V,W,Y,Z,AA,AC,AD,AE
2. Move column U to column A and X to B (from the original sheet)
can someone help me in getting this output, pls?
Thanks in advance.
I wanted to do the following actions with the help of macro.
1. Delete column B to T and V,W,Y,Z,AA,AC,AD,AE
2. Move column U to column A and X to B (from the original sheet)
can someone help me in getting this output, pls?
Thanks in advance.
Perhaps like this?
AlfSub MovDel() Range("U1:U" & Range("U" & Rows.Count).End(xlUp).Row).Copy Range("A1").PasteSpecial Paste:=xlPasteAll Range("U:U").ClearContents Range("X1:X" & Range("X" & Rows.Count).End(xlUp).Row).Copy Range("B1").PasteSpecial Paste:=xlPasteAll Range("X:X").ClearContents Columns("AC:AE").Delete Columns("V:AA").Delete Columns("C:T").Delete End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks