I put this in A2:J4 (headers in row 1):

P 0 ICMS IPI T 123 999 T 123 456
P 1 ABCD ASD T 456 666 T 888 4456
P 2 LINK LUNK T 789 333 T 321 3214

And ran that macro.

I ended up with this in A2:D10

P 0 ICMS IPI
T 123 999
T 123 456
P 1 ABCD ASD
T 456 666
T 888 4456
P 2 LINK LUNK
T 789 333
T 321 3214




Lunks wrote:

It works!
But for some reason, it only runs on the last row, not on all of them.

--

Dave Peterson