I have a spreadsheet of about 4000 rows. I have shipping box dimensions in 5 columns per box (L x W x H x Weight x Freight Class), with a total of 8 potential boxes. Columns AR - CE (40 columns) are split into the 8 groups.
Box 1 :AR - AV
Box 2: AW - BA
Box 3: BB - BF
..... and so on.
For some reason, if a row has multiple boxes (has data directly right of AV), the dimensions in AR-AV are just the sum of all other boxes. If there are multiple boxes, I need to move all data within AW-CE to the right 5 spaces.
For row 14 (and any others like it in the rest of the data sheet) I would want columns AW (The start of carton 2) through CE (the end of carton 8) to be moved over 5 columns, thus replacing carton 1 with carton 2, carton 2 with carton 3, etc.
Basically if there is data in AW, move columns AW-CE over 5 rows (*or 6 if you have to insert a columns to do a RIGHT formula)
Box 1 :AR - AV
Box 2: AW - BA
Box 3: BB - BF
..... and so on.
For some reason, if a row has multiple boxes (has data directly right of AV), the dimensions in AR-AV are just the sum of all other boxes. If there are multiple boxes, I need to move all data within AW-CE to the right 5 spaces.
For row 14 (and any others like it in the rest of the data sheet) I would want columns AW (The start of carton 2) through CE (the end of carton 8) to be moved over 5 columns, thus replacing carton 1 with carton 2, carton 2 with carton 3, etc.
Basically if there is data in AW, move columns AW-CE over 5 rows (*or 6 if you have to insert a columns to do a RIGHT formula)
