Forum Discussion
Solved
Reorder cells when dragging and replacing
Hello excel community.
I want to make a system where I can see positions of cargo pallets in sliding storage.
Let's say that each cell(color) represents one type of cargo.
...
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.
Hey NikolinoDE, thanks for the reply.
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.
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)
- Thanks!
BTW, Is it possible to automatically delete 1st row when reordering?
When A1 is moved to A6 to automatically delete empty 1st row, without any button?