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.