Forum Discussion
Reorder cells when dragging and replacing
Here is a suggested solution with VBA.
Sample file is included.
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Here is a suggested solution with VBA.
Sample file is included.
I would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
What I wanted to do is to replace the last cell with the first one and move all cells (including the last one) one row above. But not deleting any values.
- 'm a little irritated when you switch the first to the last, how are the cells supposed to go up one?
- Oh, Sorry.
I figured that I need to replace A1 with A6 and then click a button.
Neat solution. Thanks!Here again with an additional button for moving lines.
You can choose the order of the buttons as you wish :).
I also wish you a lot of fun with Excel.
Thank you
Nikolino
The more I know, the more I realize that I don't know anything.
(Albert Einstein freely based on Socrates)