Thread: [Solved] moving columns in excel 2007
View Single Post
 
Old 07-26-2011, 01:41 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

you can select different cells, but you cannot use cut function, you can only use copy-paste selection, but you can select again the cells and delete, move cells up.
Or you can use a macro, to do this. You can start with this:

Sub CopyPasteDelete()

Range("D8,D9,D13,D17").Select
Selection.Copy
Range("H8").Select
ActiveSheet.Paste
Range("D8,D9,D13,D17").Select
Selection.Delete

End Sub
Reply With Quote