How to take 3 cells in a row, move them to an area and make multiple copies based...

[krackaberr]

What i need to do is take 3 cells on a row(multiple rows), blank or not, move them to a designated area to the left and make multiple copies of them based on a cells value. Im not quite sure how to code the multiple copy. i have tried to make a macro and then i searched for code to insert into the macro and i came up with nothing. need some help on this one.

Thank you VERY much to whoever can help me on this one. im stumped

Standard Legends.xlsx

[AB33]

what happens to the cells which are blank NUMBER NEEDED? I can see you want to multiply 20 for 3 cellls, how about the others which do not have numbers?

[krackaberr]

The row that does not have a value in the number needed cell, does not need to be inserted into the table on the left.
sorry for the delay,
Thanks for looking into this.

[AB33]

Please see attached

[krackaberr]

wow, thats alot more complicated than i thought it would be. Its works just like i want it to but wow. Thank you so much.

if i want to change the range that is being evaluated would i change

Please Login or Register  to view this content.

into lets say

Please Login or Register  to view this content.

if the A,B,C columns are the rows i want moved and D is the number to multiples? just making sure of how to manipulate this code.

[AB33]

Krack,
You are right! But make sure that Cells(Rows.Count, "C").End(xlUp). need to change it to the longest column out of A,B and C. Let'say Column C goes in to the last row, the code is fine. If all colmuns A,B and C have the same size, it does not matter, you can use any of them. If you look at mine, I choose column K, not any other columns, otherwise the code will not go in the bottom of the data

[krackaberr]

what about resizing the area being repeated? changing the row size to 4 not including the "number needed" instead of 3 not including the "number needed"?

[krackaberr]

figured it out.

Please Login or Register  to view this content.

you would also need to change what was 4's (length of the last row) into the length of the new row.

Thanks again for helping

[AB33]

Krack,
I thought this thread was closed over a month ago,and was a little suprised to see it re-surfacing. If you have a question, please post it as new thread.