Folks
I have an interesting problem to work with an input file -
SKU Item Batch Assignment
12345 1
5678 NULL
7892 2
2345 3
2222 1
1111 NULL
22222 4
3333 NULL
Each Batch can take up to 2 SKU Items. I need to write a macro so that the SKU missing Batch Assignment gets assigned to next Batch, # but with a constraint that a batch can take maximum up to 2 items.
So in the above case, 5678 gets assigned to 2, 1111 gets assigned to 3 and 3333 gets assigned to 4. I am guessing this will require Iterative Macro
Please review and let me know. Thanks in advance.
Regards
Manish
Solved! Go to Solution.
Hi @mchatrvd I came up with a non macro approach it produces the output you describe. Let me know what you think?
That worked. Thanks a lot.