We have an inventory export list with 1000+ items that can be sold individually or as a package.
With these 3 individual items, I can build 2 package items defined as "AXCBGC-24" and "AXCYQ-24".
AXCBGC-24 is defined as 1x AX-924, 1x CBGC-225
AXCYQ-24 is defined as 1x AX-924, 1x CYQ-385725
We need an excel program, macro or formula that will take our inventory export list, and a list which defines Package Items, and tells us how many Package Items we can build.
Please see attached Excel spreadsheet. Message me with pertinent questions and we will award the project to whoever has a solution and understanding of what we need.