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...
There are probably quite a few here who could help you. But you could help us help you by posting a copy of the Excel file you have that is in need of that consolidation. Without knowing how the data are arranged, we could give ideas but that would be risky given your self-description as an Excel newbie. The solutions aren't probably all that difficult, but it would be asking a lot of a newbie to follow suggestions that themselves are done "blind."
Post a copy of the spreadsheet on OneDrive or GoogleDrive, and paste a link here that grants us edit access to it. Make sure that the spreadsheet illustrates the problem, but does not include any proprietary or confidential information.
- 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.
