Mirror a workbook across drive permissions

New Contributor

Hi everyone! 

I’m looking to create a mirror workbook of a workbook that I can distribute across my work place. 

say I create workbook A and save it in Drive A which only I have access to. I want workbook B to mirror workbook A and update as I update workbook A, but everyone else will save it on drive C which they have access do but I don’t.

 

does anyone know if this is possible? Perhaps a bit of VBA? I’ve already tested basic formulas but it won’t cross over between drive A and drive B. 

Thanks in advance! 

0 Replies