Excel to Google Sheets Integration
Budget: £10 – £20 GBP
I wish to integrate Excel with Google Sheets due the poor performance I am experiencing with SharePoint collaboration and the inability a live collaboration provides to filter data without all users being effected.
I have an Excel file which I will be giving me staff as a template. Let’s call this Template 1.
I wish to have template 1 programmed with VBA, so that upon a click on a button, the data is transferred to a Google Sheet (let’s call this Template 1 transfer), similar to how it is demonstrated in this videos:
https://www.youtube.com/watch?v=Qu0pD7Tq4P4
I want the values, not the formulas to be transferred to Template 1 transfer. One one worksheet will need to be transferred.
I also have a master template. Let’s call this Master Template. I wish for the data to be transferred from Template 1 transfer to the Master Template upon opening the Master Template, as demonstrated in this video: https://www.youtube.com/watch?v=ArKeYS_AUA0
In summary – my staff will be editing the Google Sheets documents through their Excel apps (with customized ribbons etc). I will open my Master Template, draw the data through from Google Sheets and be ready to go.
When I update Template 1 for my staff, it will just be a matter of sending them a new Excel file.
I have an Excel file which I will be giving me staff as a template. Let’s call this Template 1.
I wish to have template 1 programmed with VBA, so that upon a click on a button, the data is transferred to a Google Sheet (let’s call this Template 1 transfer), similar to how it is demonstrated in this videos:
https://www.youtube.com/watch?v=Qu0pD7Tq4P4
I want the values, not the formulas to be transferred to Template 1 transfer. One one worksheet will need to be transferred.
I also have a master template. Let’s call this Master Template. I wish for the data to be transferred from Template 1 transfer to the Master Template upon opening the Master Template, as demonstrated in this video: https://www.youtube.com/watch?v=ArKeYS_AUA0
In summary – my staff will be editing the Google Sheets documents through their Excel apps (with customized ribbons etc). I will open my Master Template, draw the data through from Google Sheets and be ready to go.
When I update Template 1 for my staff, it will just be a matter of sending them a new Excel file.