I need a tool made with VBA that essentially synchronizes MS Excel data for Google's worksheet and vice versa. No matter where data is stored, where I can synchronize between two platforms in a matter of seconds.
Synchronize cellular values, background colors, font colors, cell formulas, font size and more. I want to be able to choose when to synchronize and sync.
I want to call to push and pull from my own code in VBA. And then let us customize as my need. Including programmatically from VBA. Being able to schedule synchronization at regular intervals just by calling the appropriate functions by my code.
And if possible settings that can activate to synchronize only a part (track) of a worksheet.
I would use google api to sync .It will a permanent setup with high quality performance. I am a data scientists and have a lot of experience in syncing different product using api