Hi All

I've got a spreadsheet that is updated weekly and requires values to be copied and pasted in it's respective week ending cell.

My challenge is to come up with a quick method of pasting the data into it's respective cell. Ideally, I would like to click on a macro button and have it do the lookup / pasting straight away but am open to using a lookup formula.

In the attached example the EARNED TO DATE values in column A (A13, A27, A41 etc.), need to be carried over to it's corresponding week ending cell i.e. A13 -> F12, A27 -> F26 etc.

copy&paste in next blank cell.xlsx

Any help would be greatly appreicated.