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
|