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!