Move data without deleting rows

[sharky12345]

Is it possible to move data from in a column column to another and then move the source column data up without deleting the rows?

So, let's say I have data in A2:A1000 - I want to move A2:A100 to the first empty row in Column E and then move A101:A1000 up to A2 onwards.

Makes sense?

 

[Special-K99]

Copy / Paste ?
Depends how complex the data movements you need are.

 

[sharky12345]

Thanks - nothing more complex than what I've described to be honest.

The copy and paste thing I guess is probably straightforward, it's the moving up of the remaining data that will cause me the most trouble I fear.....

 

[sharky12345]

*bump*

 

[sharky12345]

Now posted elsewhere too;

Move data without deleting rows

 

[mancubus]

posted to the thread at vbax too...

Sub mrxl_880357_CutPasteDeleteRange()
    Range("A2:A100").Cut Destination:=Range("E" & Rows.Count).End(xlUp).Offset(1)
    Range("A2:A100").Delete Shift:=xlUp
End Sub

 

[sharky12345]

Perfect - thank you!