Hi there!
I've been struggling with this for over a day now and it's driving me up a wall!
I have a lot of random data that is in sections grouped by style/color/size/store. I need to move parts of it into columns to the right of the data with each style/color/size having its own set of columns and the stores and qtys received vertically under the heading. Parsing them out by size should automatically separate them by style/color.
In the spreadsheet I'm attaching, going down column J, if a cell says "SZ", everything from there to the next instance of "SZ" is its own section. So, then, in the second column past the last column of data, in row 1 I need to paste (in order going left to right) A7, I6, K6, A9. Then, in column P, below "STR", vertically, I need B7-M7, which are stores, and in S, below RECV, I need B9-M9. Below THOSE I need B10-M10 and B12-M12.
THEN, I need to find the next instance of "SZ" in column J, this need to start over, but putting the data into columns U-X. This needs to continue on to the right for as long as the data continues going down in A-M.
I pieced together a macro that did part of what I wanted, except that it wanted to post ALL of the data in really long columns in P-S. When I tried to fix it to increment columns to the right, I broke it and now I can't even get it back to how I had it then.
So, here's the broken coding that I have now:
I'm tired of looking at it and probably should just go back to doing this by hand, but now it has made me mad so I just want to beat it!
Can anyone help me finish/fix this? I'm probably overthinking it and making it much harder than it needs to be, so feel free to tell me so, if that's the case.
Thank you!!
Jenny
I just realized that a couple of my references are bad when compared to the spreadsheet I attached and are now giving me a new problem! Originally, I was working with a sheet where I had deleted some lines at the top, hence these 4 lines at the top of my code:
My text in the post was right ("in the second column past the last column of data, in row 1 I need to paste (in order going left to right) A7, I6, K6, A9"), just the coding is wrong. Sorry, I've just been looking at this too long. But that gives me the new problem of how to get STR, CLR, SZ and RECV into those header cells; I can't figure out how to reference them.
Bookmarks