I need help creating a macro to copy from a cell in sheet1 to a cell in
sheet2. Though when it pastes I can't have it fill the same cell over
again I need it to paste it in the next cell down from it.


Example:


Sheet1 -> Sheet2


B12 -> B2 and after the person clicks the macro the next would move
down to B3, B4, B5...
D12 -> C2, C3, C4... so on and so forth
I5 -> A2
I17 -> E2
G12 -> D2
I22 -> F2
I27 -> G2

I just can't seem to figure this out because I have almost 0 knowledge
of VB. Can someone help me with a step by step?