Use the macro recorder to have Excel create the macro for you, copy row 12 up to col V and paste into A13 using the paste formulas option, hit Esc and then stop recording.
This will give you the idea of what you need and something to experiment with.
Any problems or anything with what results, return here explaining the situation and someone will be glad to help.
Bookmarks