I need a macro that will move down a worksheet and duplicate each record.
Then, I need to select every other cell in a column and move the value in the selected cell left one column.
Question: How do I specify in VBA that I want to move, say, 2 cells down or 1 row down and then 2 rows left?
Thanks in advance for your help.