Forum Discussion
Consolidating SKU quantities
I'm a relative newbie using Excel to manage warehouse inventory. I have an Excel file of individual SKUs showing location, bin #, quantity and so on. Sometimes the same SKU is found in multiple loca...
I have used Excel and DBase since the 90s. In my Air Force Career, I had to used excel for many various inventors, parts and storage.
You can add another column and use Alpha-Numeric Designators for each SKU; use the File DATA and SORT functions to align all of your SKU in the same location. This lets you see everything in the workbook, worksheet.
Let me know if this helps.
You can add another column and use Alpha-Numeric Designators for each SKU; use the File DATA and SORT functions to align all of your SKU in the same location. This lets you see everything in the workbook, worksheet.
Let me know if this helps.