Macro to save workbook in locations based on the date

[hawk77EF]

Hi all,

Every week I am receiving about 10 excel files I am using to update a dashboard. The format is Analysis_Location name. I would like to create a Macro that
1. saves the initial file Analysis_Location name as "Location name_Week number" based on the date in column B of the file in location/path defined as well as the location name. Say the column B contains dates 20 July then the name of the file should be Location name_Week 30. I am doing this to keep a copy for all location in my files. Each location will have a dedicated folder with each week files.
2. After that one is saved I would also like to save it in a different location as GU_Location name.

Is this possible by using a macro?

Thanks a lot in advance.