Hi All,
I have been trying to solve this problem for a while, but have yet to get a good solution, hopefully someone can help?
I have a list of sizes/quantities:
data.png
There are many duplicates in this list, and potentially there can be 100's of lines. The idea is to consolidate and sum the quantity based on matches in Part No, Thickness, width & length... With the final result looking something like:
datasorted.png
The process needs to be macro, VBA or even database driven (as this information is exported to Access as part of existing processes).
Sorry I do not have access to attach anything or link the sample file.
Many thanks for any help.
Matt
Bookmarks