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...
Thanks for your suggestions, Mathetes. I've been fortunate to stumble across someone here who seems to know what to do so am working the problem that way.
I have this exact same problem ... I have multiple entries for the same item number, each entry with its own quantity but the same unit price and description. I want to consolidate them by item number, sum the counts of each identical item number, consolidate the unit prices without summing them and consolidate the descriptions so I have The item number, the combined quantity, the unit price and the description. How did you get yours solved?
- Goto File New and lookup Templets for your Inventory. I would add another column in front of your data worksheet. Alpha or Numeric locations A1; QD10 lower shelf. Just for example and DATA Sort can be refined to accomplish many different ways of seeing everything in that sort. Create New Columns and label them exactly as you need, with Sum HOME E =Sum (B235-B237). Templet for Stock Inventory will work just fine. Change the Column Names and enter your data directly.