Forum Discussion
perathebird
Jul 16, 2021Copper Contributor
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.
...
- Jul 16, 2021
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.
perathebird
Jul 16, 2021Copper Contributor
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?
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?
NikolinoDE
Jul 16, 2021Platinum Contributor
Is that what you mean?
In the file the example with the button "Swap 2 lines with dell empty cell"
Hope I was able to satisfy you with it.
Thx
NikolinoDE
What speaks against doing something good when nobody is looking?