sharky12345
09-04-2015, 02:47 AM
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.
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.....
Posted elsewhere too;
http://www.mrexcel.com/forum/excel-questions/880357-move-data-without-deleting-rows.html
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.
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.....
Posted elsewhere too;
http://www.mrexcel.com/forum/excel-questions/880357-move-data-without-deleting-rows.html