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.