Hi,
I am trying to create an Excel Macro in Visual Basics for a complicated formula for the beginner that I am. I need to take data from one sheet and put it onto another sheet in the same book depending on certain variables.

Basically what I am trying to do is this:
If cell D12 from Sheet 1 says "2015" then put the value from cell R12 in cell D9 of Sheet 2.

This process should continue as such:
If D13 says "2015" then put the value from R13 in D10.
If D14 says "2015" then put the value from R14 in D11.
Etc.

Also, I need to expand this further in a couple different ways. The first one being:
If D12 says "2016" then put the value from R12 in cell E9.
If D13 says "2016" put the value from R13 in cell E10.
Etc.

The second one:
If E12 says "2015" then put the value from R12 in D9.
If E12 says "2016" then put the value from R12 in E9.
If F12 says "2015" then put the value from R12 in D9.
If F12 says "2016" then put the value from R12 in E9.
Etc.

Does this make any sense and can it be easily coded?
If you have a code for this, I would be very grateful!