I need VBA for my data I.e. i have following data
QTY Cut# Size Bundle #
36 496 2 1
26 498 4 3
26 498 6 4
26 498 8 2
26 498 10 7
This is my current data i need this in following output. I have a too large sheet of this data.
QTY Cut# Size Bundle #
36 496 2 1
26 498 4 2
26 498 4 3
26 498 4 4
26 498 6 5
26 498 6 6
26 498 6 7
26 498 6 8
26 498 8 9
26 498 8 10
26 498 10 11
26 498 10 12
26 498 10 13
26 498 10 14
26 498 10 15
26 498 10 16
26 498 10 17
In bundle column if we have 2 bundles then our VBA should add one more rows if we have 3 bundles then our VBA should add 2 more rows and so on. Kindly do the needful as soon as possible.
Regards
Pari
Excel Learner
Bookmarks