(Solved) – Macro to Paste Values “X” Number of Times [closed]

  • by
(solved)-–-macro-to-paste-values-“x”-number-of-times-[closed]

I am fairly new to VBA and am wondering if someone could help me out. I am completely lost…

I have a Sheet (“Sheet 1”) that has a column (Column E) with a number in each cell from E2:E50 (Each cell has the number 1, 2, 3, 4, or 5).

What I want to do is copy the cell (in Column F) next to each number and paste that value into Column C of another sheet (“Sheet 2”) based on the number in column E (If E2 has the number 4, I want to copy F2 and paste it to the next 4 open Cells in column C of Sheet 2). I want to continue to loop through all of the cells in column E of Sheet 1.

Thanks so much for your help!

Leave a Reply

Your email address will not be published. Required fields are marked *