Sorry for title, tried my best!
I have a workbook called DPD.xlsm. I would like it that every time a user presses "save" it overwrites a different .xlsm workbook called "Import.xlsm" that always resides in the same folder directory it also needs to then save a second time as it normally would...