Good evening everyone,

I have two files that I work on a monthly basis to finalized account monthly returns.
The Prod file - the Source
And
The Archive file - the Destination file.

What I would like to do with the macro is to send the Account's Monthly Return from the Prod file and archive it to the Archive file.

The Code would translate like this:

Sub Archive_Return ()

From the Active wbSource/wsAllResults
If Column N (Account Status) = "Final" Then
Copy the Return in (Column S) for the Account in (Column D) and for the Month Period in (Column E).

(I want the code to do it on a "Per Account" basis instead of range so each account row will have a button)

With the copy Return from the Prod File,
Paste Special Value the Return to the corresponding Account (Column A) and Month Period ( Jan is in Column E to Dec in Column P) in the wbDest/wsTotalReturns

(In this instance the Month Period is Feb so the Source Return has to be archived in the Destination file where the Account is for Feb)

( here I don't know how to code it to look in the Archive file for the Account in Col A and the corresponding Month Period row header)

Save Archive file.

End Sub

Note:
The Archive file is a Table/Matrix format - has all the Account Codes in Column A and all the Month-Periods in row 2 with month headers starting in Column E with Jan and ends in Column P with Dec.

Hope this helps explain the code.

Thanks in advance.