Create a macro that will duplicate rows by a number of times in a cell

  • :huh: i have a worksheet with columns A-R and Column R has a number of orders. if column R has 5 orders, i need to duplicate that row 4 more times to have a total of 5 rows.

    help me!!!! I'm a very beginning level with VB!!

  • Assuming your data starts in row 2, try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.