Hi,
I'm not necessarily looking for a solution (right now), but can i hold a workbook with all my "report" worksheets on it, that would be populated from from my local workbook?
Currently my work book has multiple different "report" sheets that are blank and then when a macro is executed it will cycle through and populate cells then either print (print macro) or copy and email (email macro). For example I (potentially) have multiple days, lets say 10. So when I want to print out either a single day or all of the days I use either Print or Print All macro. It then takes the data, populates the sheet, or multiple sheets (depending) and then prints them.
Now instead of having my "report" sheets in the local workbook, could I store it on the cloud, either google or one drive etc. then access the remote report then print or email from the local workbook?
Thanks for your help.