Hello all. I am fairly new to VBA, and have been stuck on this for a while now, and wondering if anyone might me able to help me out.
Is there a way to loop through a specific column, copying and pasting each cell X number of times (the value of X is in the adjacent column) to a new worksheet?
For example if in column C I have the string "Large Cap Core", and adjacent to it in Column B, there is the number 2, I would like to copy and paste the string "Large Cap Core", into a new worksheet 2x. If the number were 3, copy and paste 3x, and so on.
I have attached a sample workbook with the setup and desired results so you can get a better idea of what I am trying to accomplish. Any help or ideas that you have are greatly appreciated!
Thank you!
Reply With Quote