Need help with my first For Next Loop

[powersml07]

Good afternoon everyone. I need help with my first For Next Loop. What im trying to accomplish is take a set of data all in one column and separate them into different columns. Below is what i have so far. it works for what im trying to accomplish for the most part, but i need some help with a couple tricky outliers. Wondering if someone here could help (where i need help im annotating in bold)

Please Login or Register  to view this content.

[TMS]

Work your way up from the bottom and then you don't need to keep going up and down and selecting cells.

Or, just don't cut the cells. Just copy and paste the entries into their respective columns and then delete the source data in one go.

Please Login or Register  to view this content.

[powersml07]

Im not sure that would work. The need for those IFs are they need to line up with a SKU. The majority of those SKUs have 5 columns, however the outliers that dont ruined my FOR NEXT Loop. Thats why i had to start to include the IF statements. When those outliers occur, i also need to stop the loop and start it over. Example of how my data would look would be

Please Login or Register  to view this content.

What im trying to do is put 100 from ABC SKU and put it in the 3rd column, 250 from ABC to the 4th, 500 to the 5th, 1000 to the 6th. then repeat to the next sku. IF you look at SKU GHI though, you notice that data only has 4 numbers associated with it. Thats where the IF statement would come into play and why i would need it to start at the top of the loop when going to SKU JKL

hope that helps

[TMS]

That was not what I understood from what you described.

If column A has blanks, you can check that and store the product row. If it's not blank, you copy (not cut / delete) the value to the next available slot on the product row.

When you get to the bottom, Filter column A for blanks and delete the visible rows.

Post a sample workbook with some typical data.

[powersml07]

Hoping this works. Here should be a sample set of data to what ive been working on

[TMS]

What's with the 12 in cell B6?

[powersml07]

my fault. i was just using that 12 value to test one of the IF statements

[powersml07]

Thanks for your help TMS. I figured it out. I just put a GoTo step in the ELSE statement that brought it back up to the top of the LOOP

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.