I work for an apparel company. We have image boards containing all seasonal designs, and a matching excel grid containing other useful information. Here is a small board with images:
The order of the board images is important, so I need to be able to sort my excel grid by the order of images. We assign order numbers left to right, top to bottom, just as someone would read a book. I’ve constructed my excel grid to look like the below:
To create the order, I wrote my formula as A[row number 1 above] +1
. So cell A2 = 1
, cell A3 = 2
, cell A4 = 3
, and so on.
This is all fine and dandy until we come across 2 situations:
#1 I have to sort the other columns. I sometimes need to sort column F
“Forecast volume” by ascending. This obviously messes up the order in column A
.
#2 I need to add a new style in as a new row, while still maintaining order in the grid that matches to the image. See below image. I want to add a burgundy color to slot in as item #5, while automatically adjusting adding 1 to the rest of the items below it.
Here is my file for reference. Is there a solution that allows me to add and sort rows, while still being able to order my styles correctly, according to the provided images?
Thank you!