Macro Problem

[mchatrvd]

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

[JosephSerpis · Accepted solution]

Hi @mchatrvd I came up with a non macro approach it produces the output you describe. Let me know what you think?

[mchatrvd]

That worked. Thanks a lot.