Jul 16 2021 09:01 AM - last edited on Jul 21 2021 06:16 AM by Allen
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.
When Red pallet repositions to A5, I want to move all other painted cells automatically up by one row instead of just replacing it with Purple. Image example provided below.
Is this possible to do in Excel? If so, any guidance is very much welcomed.
Jul 16 2021 10:07 AMSolution
Here is a suggested solution with VBA.
Sample file is included.
I would be happy to know if I could help.
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.
Jul 16 2021 10:25 AM
Jul 16 2021 10:41 AM
Jul 16 2021 10:48 AM
Jul 16 2021 11:12 AM
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.
The more I know, the more I realize that I don't know anything.
(Albert Einstein freely based on Socrates)
Jul 16 2021 11:15 AM
Jul 16 2021 11:23 AM
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.
What speaks against doing something good when nobody is looking?