Southernwave
01-06-2017, 08:18 PM
I have a worksheet where I need to reorder the sequence of rows.
Currently I add a numbered sort column and then sort the rows (actually part of the row) with a macro.
What I would like to do is move rows (actually part of the row) up and down by select and drop.
A couple of issues.. I want to move a (pre set) number of cells in the row.. so other cells that do calcs stay in place
I want to move all the ,below where I want the moving rows to go, down to place the moving row
The row would be moved and not pasted
No data would be lost via the operation
Maybe the option to move any cell conditioning with the moving row.
All the methods I see at the moment are cut and paste (so data lost) or move the row occupying the slot to the bottom of the list.
Has anyone tried ( and succeeded) to do this sort of thing ?
Cheers
Andrew
Currently I add a numbered sort column and then sort the rows (actually part of the row) with a macro.
What I would like to do is move rows (actually part of the row) up and down by select and drop.
A couple of issues.. I want to move a (pre set) number of cells in the row.. so other cells that do calcs stay in place
I want to move all the ,below where I want the moving rows to go, down to place the moving row
The row would be moved and not pasted
No data would be lost via the operation
Maybe the option to move any cell conditioning with the moving row.
All the methods I see at the moment are cut and paste (so data lost) or move the row occupying the slot to the bottom of the list.
Has anyone tried ( and succeeded) to do this sort of thing ?
Cheers
Andrew