I have attached a copy of the workbook below and what i am asking is
this. I have multiple reserve locations by SKU, for example sku:247294
has two backup locations (r2023,r4007)and in the next column the total
amount of units extra that will fit into the location. What i want to
work out is will reserve location 2(r4007) stock fit into reserve
location 1 (r2023)and vice versa.
Then workout for the remaining SKU's

INUMBR WHSLOT ILONGD WHSLOT01 WHHAND01 Total fit in Location
247294 A1004 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) R2023 64 120
247294 A1004 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) R4007 178 6
149403 A1005 BEKO WMB10W 1000RPM WM (5,BBC,WTT) B1011 194 56
149403 A1005 BEKO WMB10W 1000RPM WM (5,BBC,WTT) C1031 238 12
247308 A1007 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) B1043 154 22
247308 A1007 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) B1044 164 12
247308 A1007 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) D6019 34 22
247308 A1007 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) R3003 128 48
247308 A1007 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) R3008 176 0
Many thanks

Gordon