Forum Discussion
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.
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.
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.
7 Replies
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.- 'm a little irritated when you switch the first to the last, how are the cells supposed to go up one?
