Sorry for this but need help taking am excel opened on sharepoint and duplicate it on another SP site


The process would be as follows:

Click’s button to save a file.

1) File saves to Secondary SharePoint "http://SP2"
a. Updates name to current date example “RAID Log – DD-MM-YY”
b. Any previous version in the folder is moved to folder “Archive”
2) File saves to Primary Sharepoint "Http://SP1"
a. Updates name to current date (as above)
b. Any previous version in the folder is moved to folder “Archive”
c. File closes

Is this something you guys could help with?