Open the MMR and save it to your computer with your Property Name_Property #_MMR_Date formated XX.XX.2024

Click the button to 'Press to Update Prior Week

If you get an error about your Macros > Right click Column C > and Click Copy > Right click Column D > Choose the 123 paste option

Next, click on Data > Refresh All

**The first time running the report will not have the prior week and you will need to pull from prior report. 

You may receive this message that excel couldn't authenticate with the credentials provided.  You can click on Microsoft Account to sign in with your OC login > Make sure you have selected the olympusproperty.sharepoint.com/MyDashboard/Operations/revenue management > Click Connect

Once it connects, the first time to run all of the data takes about ~10 minutes.

Each week going forward, open last weeks report

Click the button to 'Press to Update Prior Week

That should replace Column D with last weeks information

If you get an error about your Macros > Right click Column C > and Click Copy > Right click Column D > Choose the 123 paste option

Change the Week Start Date to the current Date > Click the Data > Click Refresh All  (Data will take 3-5 minutes to refresh)

If you run into any issues, please reach out to [email protected]