Also, I have a request that could make things easier.
I'm stupid and yell at me please.
Instead of me making the cells lavender at the edges of blue regions, and then Clear Contents-ing them later, why don't I just do a Right Click --> Insert --> Shift Cells Down command (for Column A/B (dependent), for Column D/E (dependent))?
Is this possible to do in either a Keyboard shortcut where I manually select the blue region and run the keyboard shortcut? or is there a macro that can find the start and end of blue regions and do the Right Click --> Insert --> Shift Cells Down command?
(the lavender procedure is just to get a "space" cell in the final product)
So do you see what I'm saying:
On the unedited, suppose it's just black and blue (and red) (no lavender)
Step 1: (Shift Cells Down)
Black
Blue : Right Click --> Insert --> Shift Cells Down
Blue
Blue
Blue
Black : Right Click --> Insert --> Shift Cells Down
Step 2: (Remove All Black Cells, Shift Up)
Black
"Space" cell
Blue
Blue
Blue
Blue
"Space" cell
Black
Final Product:
"Space" cell
Blue
Blue
Blue
Blue
"Space" cell
Is this possible?
Bookmarks