Hey everyone - I don't really know how I would word this in a google search so I hope that you amazing wizards are able to help guide me in trying to better understand.
I built a sales pipeline management workbook that's pretty intricate with auto populating formulas and a whole bunch of custom macros blah blah blah. I've deployed it out to a few people who wanted to use it for their businesses and at least every couple of days I find a bug, and fix it, and move on with my life. But if I send a friend the newest version with the fixed bug, they have to manually copy and paste a bunch of data and some of them aren't super excel savvy and will most likely screw something up.
If I wanted to have a master copy where 1 worksheet out of the 5 that are in it is linked directly to their secondary copy, anytime I update code / formulas on the master, as long as they hit refresh it'll automatically update their code / formulas on their end.
Is something like this possible?
If not - is there a way to create an upload option in the workbook where they can upload the previous version into the new version and it auto updates specific criteria?
Thank you!
Bookmarks