This will be a private sub that will go in the buttons on my userform:
1: Save file with its current filename in "v:\dept2"
(Make sure it warns if it could possibly overwrite something)
2: Verify file is present in v:\dept2 (important because it is on a sharepoint server)
3: Once verified, delete file matching current filename from v:\dept1
Bookmarks