Hello there,
The below code should work for you:
PLEASE NOTE: I have highlighted the line of code that you will need to change to your Save as filepath red in the below code. If you do not know the file path, open a workbook in the folder/location and in an empty cell type =CELL("filepath") this will give you the location.
To insert this code
1. Press Alt+F8 on your keyboard
2. Clear the macro name field
3. Type the following in the macro name field SaveIBPQtrlyUpdate
4. Select the Create option
5. In between the Sub SaveIBPQtrlyUpdate() and End Sub copy and paste the above code, anything that appears in green is a comment meant to help you understand
6. Change the file path as instructed above
7. Close out of VBA and then press Alt+F8 again
8. Select the SaveIBPQtrlyUpdate macro and select Run.
Let me know if this works for you!
Thanks!
Bookmarks