How To Create A Real-Time Sync Between Excel & Google Sheets Without Excel Add-Ins [Free Download]
Vložit
- čas přidán 21. 07. 2024
- 🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN CZcams MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to sync Excel with Google Sheets, both ways.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/GoogleSync_Wb
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:26 - Overview
3:40 - Change Event Worksheet
28:40 - Sync from Google
36:04 - Run Sync
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #googlesheetssync #googlesheet #excelvba
![How To Create Your Own Cash Flow Calendar In Excel [Full Training & Free Download]](http://i.ytimg.com/vi/CdyMGQsQfXY/mqdefault.jpg)
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► rebrand.ly/FreelancersAcademy_YTPinnedCom
Good Morning Randy, I have been working on this very topic the last week. It is almost like you read my mind, because this happens so often. May your day be blessed
Thanks so much Al, I am so glad I can help and I always appreciate your comments.
Being great full to #drogoco you have put a smile on my face with just your herbs to cure hsv.
As usual again a great training. I really appreciate the work you put in every time :)
Thank you so very much, I am so glad you liked the training Bart.
Being great full to #drogoco you have put a smile on my face with just your herbs to cure hsv.
Hi Randy! Awesome tutorial! I am trying to sync data in Excel with dropdown lists in Google forms. So far, I have figured out how to sync Excel with a Google Sheet and how to feed data from a Google Sheet into a drop down list in a Google Form. The second part requires running an Apps Script. Is there a way I can initiate the Apps Script from Excel using vba?
Hi and thank you can use a webhook within Excel based on any trigger to them connect to Apps script. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Great idea, great workmanship
.
Thank you very much.
Thank you very much. I do appreciate that Piotr
Nice tutorial, thank you!
Is there a way to solve the encoding issue of special characters? For example an "Æ" character (from Scandinavian alphabet) returns as "Æ" on the destination sheet.
Hi Alex, yes there is a great way to solve that using the character equivalent. For example the checkmark would be Chr(252)
You can use this in place of any character you like. I hope this helps and thanks so much.
Hi Randy! Amazing really enjoyed your tutorial, I just wonder is there any possibility to accomplished the same without third party application.? Thank you in advance
Hi and thanks so much. It may be possible however you will need Excel to complete the Google OAuth which can be tricky.
I hope this helps and thanks so much.
Hi Randy, Thank you so much your many tutorial. This is my 1st time comment to you. Thank you very much 👍🏻
Hi Leung, thanks so much for your comment. So great to have you here.
Amazing knowledge!!! Thanks!!Did it & it works fine. But it updates on manual edits only. When got changes in file with macro, changes doesn't reflect on Google sheet.
HI and thanks very much,. It should trigger change with a macro as well, just make sure you are only changing one cell at a time. I hope this helps and thanks so much.
Randy you are a blessing! God bless you
Thank you so very much, I really appreciate that Isaac
Thank you so much, dear! It's great as always
For sure, you are very welcome Mai. :) :) :)
That must be the most useful video i've ever seen . Thank you so much
Glad it was helpful and thanks so much.
Love this training!
Thank you very much. I do appreciate that Susie
very wonderful :) Is it operating with graphs or pivot table too when I use them in the Excel File Sheet? Is it operating when i have a data model with databases in the background of the excel file?
I need just excel to google sheet direction, but is it operating if i would copy the vba code for the Sheet2, Sheet3, sheet 4, etc... ?
I know, I have many question :) I've asked to connect to your FB group too. Thank you the video and the answers :)
HI and thanks so much. This one is basic as it covers just cell to cell sync however you can download this and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Great video!
Is there any way to get the whole sheet updated at once instead of cell by any chance? This method works well but only updates one cell at a time unless I've done something wrong
Hi and thanks, You could sync entire sheets from Google to Excel using External Data source from web. From Excel To Google sheet, you could save an excel file in Google drive then open it in Google sheets. I hope this helps and thanks so much.
Hello! First of all thank you for your job, and for those free tranings.
I tryed this example and I have a problem with command "Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")". I tried some examples to solve this, but nothing works. Can you help me?
Thank you!
HI and thanks for your comment. Please check for a missing reference library and also download my free application using the links in the description to compare. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
This is an amazing video, thanks a lot!! Just one question.
I want to create a dashboard in Google data studio that is refreshed whenever some tables in SQL are refreshed, however I cannot connect Google data studio to SQL tables.
I can connect Excel to SQL, so I thought to connect Excel to SQL, then excel to Google Sheet and then Google studio to Google sheet.
Does it make sense to do all of that as a workaround?
I have never used Google data studio so I would not be able to help you with that.
Thank you for your Likes, Shares & Comments. It really helps.
Love this code and training. Just Awesome
Thank you very much. I do appreciate that.
Sir, thank you for your hard and continuous work. Could be possible to create a real-time sync for multi-users between excel din Microsoft Teams Application? In these difficult times we are using more and more Teams for online activities.
Hi Cristian, thanks so much for your comment and question. This training can easily be adapted for teams as long as you connect teams and have all members using a shared folder. I hope this helps and thanks.
Its amazing as always...
Please make a brief video on syncing Microsoft excel sheets.
Hello Jawad, thanks so much for your comment. i will add it to my list. Much appreciated.
I used google sheets on my iPhone and it worked great for use as a baseball manager. Great tips in this video
Oh thats great. Happy to help
Hi sir, I'm from Philippines. Thank you for this tutorial. Love it. I already done subcribing and hitting the bell. God bless.
Thank you so very much, I really appreciate that Ronilo. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
Thank you for creating this wonderful video.
One quick question - I use Mac and ActiveX is not supported for mac so I am unable to use the MSXML part. Any workarounds to that for Mac users?
HI and thanks so much Karan, there is a great channel for Mac users on Excel that may have some solutions here: www.rondebruin.nl/mac.htm
@@ExcelForFreelancers Thank you and keep up the good work!!
Great video, many thanks. I have bought a course from your website and its awesome.
Is there any way to make the cell sync when I copy and paste new cell instead of writing them in? Double clicking on each cell for large database would take forever. And when my AppSheet is updating the google sheets my excel is not updated with new value do you have any solution please ?
Hi and thanks you may want to sync a different way, perhaps trying this training: To share and sync your macro-enabled Excel workbook, please watch this training: czcams.com/video/f_1HsR9305I/video.html
Thanks for the content you create... thanks !!!. By the way: Can Google Sheets open (and run seamlessly) excel files with Macros?
HI and thanks very much for your comment Enrique, Google Sheets uses scripts which are very different than macros so they cannot be run seamlessly. You can share and sync your macro-enabled workbook with anyone in the world using this training: czcams.com/video/aKV5seZmiBs/video.html
I hope this helps and thanks so much.
This is what I've been looking for.. Thank you for giving us such a great video..I had a question though. Will it work if I use Google drive or OneDrive instead of a dropbox?
HI and thanks very much. Yes this should work in any shared drive folder. I hope this helps and thanks so much.
thanks, it works when add data cell by cell to excell. . how is possible to add more data(copy/paste) in excell and work?
Hi and thanks you can use Ranges as well via the Integromat functions. I hope this helps and thanks so much.
Cant wait this vid
Thanks so much Raymond
hi, I used this concept on fetching data from a database using ms query and I encountered an error in the macro script telling that 'type mismatch' and it is highlighting in yellow the Cellvalue. In Dim you have declared CellValue as String, is it the same case when the result of my query in the sheets is in a data table.
Hi JS, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
I have a question, I was doing the same thing you just did where you eliminated the space between Column and row number in integromat. For me, the error still persists. Where it says theres spacing between for example : "C 1"
Any clue why it would do that?
Hi Ryo, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
(you can also post it in an Integromat facebook group as well)
Hallo Mr. Randy, What is meant by 1000 operations and 100mb of data transfer on Integromat service? Thank you.
God bless you.
Hi Risandi, that means you can send 1000 webhooks or have 1000 actions on Integromat with a maximum of 100mb for free each month with Integromat. If you need more you can check out their payment plans. I hope this helps and thanks so much.
You just aided me in my final project thanks!!
Great. I am happy i could help Ekow
This is absolutely amazing advice
Thank you so very much, I really appreciate that Mahabub
That's amazing. Thanks Randy
For sure, you are very welcome Syed
very useful,thanks :)
i have a question, is it possible to get data from webste using excel?
how about automate trading binary.com or binomo using excel, is it possible?
or get data news into excel realtime?
HI thanks yes it is certainly possible. Newer versions of Excel do this very easily and older version can also link and download via RSS feeds (more than I can explain in a comment so you will want to research it)
Thank you for your Likes, Shares & Comments. It really helps.
Hello Randy, thank you for this great video, just one question this doesn't seem to be working with a g sheet connected to a google form, a new entry on the form doesn't update the excel file
How to solve this?
Hi and thanks so much. I have a specific video on this here: czcams.com/video/EA_0p_9E8u0/video.html
I hope this helps and thanks so much.
Good Job. Thank you
Thank you so very much, I really appreciate that
Hello! I really love your videos, this is just to adk if it is possible to use other platform instead of dropbox?
HI it should work with Google Drive or Microsoft One Drive or a few others. DropBox just happens to be my favorite. I hope this helps and thanks so much.
Thank you so much. This is a great tutorial!
For sure, you are very welcome and I am happy to help and share
This is amazing. Thank you so much
For sure, you are very welcome Oliver
Is it possible to configurate the sync from excel to Google Sheets on a timely basis instead of whenever there is a change in the worksheet?
Hi Martin, thank so much for your comment. Yes it is possible using the Application.OnTime command in which you can run a macro at a specific time or specific time interval.
I hope this helps and thanks so much.
This was a really good tutorial, it helped out immensely in organizing some D&D character sheets for me between friends.
I did notice that I couldn't quite get the Excel side to update as neatly though, is there a setting I need to flip for it to just run without crashing?
Hi and thanks. You can check for loops in your Worksheet Change even which can sometimes cause endless loops and crashes.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
You are a great teacher
Glad you think so and thanks so much Osama
Nice sir. I have a question, does it sync also the formula or just the result only of the formula used?
Hi, this will only sync values, since formulas can be different between Google sheets and Excel, however you can give it a try with Formulas. I hope this helps and thanks so much.
Really amazing, from new to newest , ( ALLAH ) god bless you friend ...
Thank you very much. I do appreciate that.
Is there a way to sync only a specific range of a connected sheet? for example, I have an order form response sheet connected to an excel workbook. I want to shorten my headers in excel and hide orders that have already been shipped. Every time the sheets sync, everything goes back to defaults.
Hi Jessica, thanks so much. The best way to handle this is with two sheets. One that contains all of the data, and another that has the filtered data that you want. You a use advanced filters for that. I have a training video on that here:
czcams.com/video/YuCrEWU2Tm0/video.html
I hope this helps and thanks so much.
Very nice. Thank you. And thanks for no music! :)
For sure, you are very welcome, I am glad you enjoyed it. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
nice explanation: Sir can you make a demo how to sync the google sheets and auto generate to website files so that every time i update my sheets it will reflect to the website in real time.
Hi and thanks Jair, I would have to incorporate Excel in some way as each of my videos must use Excel in some way. Thanks for the nice idea.
Hi Randy,
Thank you for the info.
Is there any other way I can do this without using any third party website?
Hoping for the reply.
Thank you:)
Hi and thanks. The difficult is the oAuth (which means authorizing the Google site within Excel) So this authorization is done by 3rd party sites. There may be a way, however it requires some additional research. I will check it out and thanks.
Great tutorial thank so much for this!
I have Hebrew in my sheet and on the google sheet it shows up as gibberish, what can be done?
Hi and thanks you can use the character equivalent such as Chr(252) for the checkmark. Please check your Hebrew font for the specific character codes for those characters.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Dude: that was amazing. Thanks
Thank you so very much, I really appreciate that Leon.
u r awesome sir. Thank in advance u made my day👍👍
Thank you very much. I do appreciate that Raymond
Very useful, thank you.
I have a question, how much will it change if I want to use it on multiple worksheets?
Hi Peter, thanks for your comment. You can just include the sheet names to specify which sheet it is syncing to. This feature will work on unlimited sheets.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much
I have one other question, Can the code handle that if I create a new worksheet in google or excel, for example, can it also synchronize it?
Thank you.
HI and thanks it may be possible, by writing code to loop through the sheets as along as your sheet names follow a clear pattern "Sheet1" , "Sheet2", etc.
I hope this helps and thanks so much.
March 2021 and still working, great! Thanks a lot
That is great to here. thanks so much.
@@ExcelForFreelancers Im having a "run-time error 13 type mismatch" error when paste more than 1 value at the time :/
Hi and thanks you can add right under the worksheet change event
If Target.CountLarge > 1 then exit sub
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Hi thank you so much for great tutorial. Please teach me how to make a sales plan for electricity branch with bill printing with Excel. Thank you very much.
HI and thanks for your comment. I am unable to take on any custom projects, however If you would like some help with this, we have a group with 30,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
I love everything you. thanks for sharing
Thank you so very much, I really appreciate that Diego.
Thanks Randy.
For sure, you are very welcome
I've noticed that whenever I paste large sets of data or try to drag formulas, nothing populates in my google sheets? Is there a way to do that?
Hi and thanks. Yes you can modify the Scenario in Integromat to work with large ranges. The focus of this training was for only single cell changes. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
woow really awesome
Thank you so very much, I really appreciate that Proje
Wow that is what I need, thanks so much
That is great to hear. Cam on ban
@@ExcelForFreelancers oh you know vietnamese 😀
Just a little bit. I live in Da Nang. :) It is a beautiful city here. :)
Hi , Randy amazing but how can i perform this step i have table automatic updated from a query
so i want to syncs this changes to google sheets like update cell value
i'm trying to use get range , but it fails
how to read this changes in table to googlesheets automatically
thanks
Hi Tommy, thanks for your comment. This type of sync should only be done with a single cell at a time and not as a range. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
You really made me love excel
That is great to hear Omar and thanks so much
Hi.. Thank you for your valuable tutorial. But i have some issue in Webhooks when run the Scenario. it shows "Cannot initialize the scenario because of the reason 'Flow is empty and contains no configured module" and after that Scenario initialization failed with an error. How do i fix that? I need your help.
Hi Sameera, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
will formatting in GS transfer to Excel? Also it will not work without the Integromat right?
HI Jun and thanks for your comment. This particular solution works with integromat. It may be possible, with additional coding and scripts to add formatting as well however I did not attempt to add the formatting as this training was just focused on the date. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Thanks, it really help. Maybe you could help with adding the code for formatting please? Thanks!
I'm also getting another problem - my data uses cyrillic characters, but integromat doesn't seem to be compatible with anything but latin characters. Is there a way to push data containing cyrillic characters from excel into google sheets? Thank you!
Hi and thanks you can check with Integromat Help documentation for how to do this. Thanks again.
There is any chance to connect Excel as API Database to a Website instead of Google Sheets using Integromat??
Absolutely. Integromat has a database as well. I will make a video on this in the future. I hope this helps and thanks.
Thanks. This is great. However, when I delete an entry on Google Sheet, it does not update as the macro brings up a run time error. Anyway to sort this?
Hi and thanks this should not cause a bug however you can make sure that only 1 cell is modified at a time, and also check your code for possible issue. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for sharing your files... I have a question can I entry multiple user in Google sheets and data transfer in Excel sheet same time with multiple user??
Hi and thanks. Yes you can. i have a training video on that right here: czcams.com/video/aKV5seZmiBs/video.html
This is brilliant, thank you! Firstly, just a concern about having to make the public sheet access public and because it requires a 3rd party to translate the information between them. Is it still secure as it would be containing confidential information and figures. And secondly, is it possible to have this setup to sync a Table (i.e. If a new row is added, edited or deleted on the G-Sheets side or Excel, then both will auto-update and both Tables will always be identical)?
HI and thanks so much. I am really glad you liked it. Only someone who has an exact link would be able to access the data. I would think it would be find for most types of data, but not the most sensitive of types. Concerning new rows or columns, it is certainly possible as long as you have allowed that within the code, meaning the change event must encapsulate the entire range you want syned.
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers Hi, thanks for getting back. Ok great. Right, so I don't just want cell data in Google Sheets that matches what is in Excel, I want it to be an actual Table in G-Sheets that can be treated as a Table (e.g. Filtering). However, I am not actually sure that this tutorial works anymore. Integromat has now changed to Make (so you don't have to worry about pronouncing it now haha). I followed your instructions and I get as far as creating the webhook and entering the link into VBA. I then type something into a cell to test it and VBA highlights the "CellValue = Target.Value" part of the coding for some reason? And the webhook does not say it was successful. In fact when I go into the webhook, it gives the option to "Redetermine Data Structure" instead. I don't understand what I am missing? When I try to create the second Module to connect to G-Sheets, I find the sheet I have created, "Map" is further down and I don't have any of the options it showed for you (SheetName, Column, RowNumber, etc). Do these options only show once it has successfully linked to the VBA? (I am not on Fb)
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Hi, is there another option to upload? As, like I said, I am not on facebook.
Hi, Thank you for your work. I downloaded your work "Real-time sync Between excel & google sheets" It works good but when I delete/erase the info. from google sheet, "Run-time error '62': Input past end of file" error code poping up and codeing does not work. How can I fix this issue?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
i got round this by adding , after "Open FilePath For Input As #1", the following lines
If EOF(1) Then
CellValue = ""
Close #1
Else
Line Input #1, CellValue
Close #1
End If
Thanks a lot for the video. Is there any way to update the cells from excel to google sheets when the data in excel changes automatically? lets imagine the data is coming into excel from an external data source? tried that in your solution, but not working. any help would be really appreciated. thanks.
Hi and thanks for your comment. You can trigger the macro on a change event of any cell, so user the Worksheet_Change even with your specified cell range. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers thanks so much for your response
Will join the group 👍
@Excel For Freelancers one last question here, promise it will be the last ☺️
Integromat has the facility to update cell by cell as and when it changes, and each cell update is being considered as one "operation", but can we use it to make the update of a range of cells to indicate one single Operation?
I am very happy with this video. But I have small request how to sync formats and how to sync sheets and ranges of data
Hi and thanks. I also got your email on this question as well. Please check your email for the response. Thank you.
Hi Randy, You are awesome.
I have created an excel application taking inputs from your videos. I want that application login link with Google login . What I mean that the application is used only when user is already logged in his Google/Gmail ID . The purpose is to give access to only that Google ID and only the person login to his google domain then can use it so that securing that the application is not shared.
HI Manoj, thanks for your comment. When you initially set up a Google Sheet you can then assign permissions for that sheet. Then only those who are logged in would have access to that sheet. I hope this helps and thanks so much.
Amazing video sir,
Thank you so very much, I really appreciate that Abdul
I really appreciate the work you put in every time, however, am facing problem
when i try to connect my excel file with webhooks its not working, i copied the link as you explained but still not working,
what wrong i did !
Hi Gondor, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Yeah this 1 very cool 😎
Thank you very much. I do appreciate that.
Espectacular thanks
Thank you so very much, I really appreciate that Carlos
Great Video!! i seem to have everything but the Application Part. I am Receiving an error saying "Cannot run the macro "C:\Users\etc....\Excel link.xlsm'!SyncFromGoogle'. The macro may not be available in this wookbook or all macros may be disabled."
If i take the application part out and the Run Sync at the bottom everything works but i have to manually run everytime.
Also when running debugging and going to "step into" it will not get past the first 3 lines with the Sub run sync added.
Do you know what could be causing this and what the fix would be?
Hi and thanks you can right click any shape and assign a macro to it. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi Randy. Loved your Tutorial. But I'm having trouble when verifying that the code is running on Webhook. When I go back from my file to integromat, the Webhook doesn't show "Successfuly determined". I checked and rechecked my code. It looks just like yours (save the URL, witch is mine). What could be the problem? Thanks for all your contribution.
Ah! Forgot to tell. That when I add the Google Sheets module, and map it, it doesn't show the same names on my code.
Hi Mariana, Thanks for your comment. Make sure you are using your own webhook and have replaced mine in the code. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi, Thank you for the video really helpful. However, I can't find the Map switch on and add the 1.SheetName or 1. Column etc... can you please advise. Thanks
I use mac
HI and thanks so much. I am not sure of the exact issue however Mac's are different. You can learn more about those differences and for guidance here
www.macexcel.com/
I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
can excel sync between few cell. say, i wanna A1, C1 and G1 wanna always have same value?? either cell i edit A1 C1 or G1, will change other 2 cells . if can, please let me know how
Hi yes you can use cell links with a formula or you can use the Change Event in VBA to match cell values. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
Good Morning Randy, thank you for information ,please i want change Dropbox by onedrive for transfer the database in google sheet to excel ,thank you .🙏
Hi and thanks, yes you can do that for sure. Thank you for your Likes, Shares & Comments. It really helps.
Can you help me in this way, thank you@@ExcelForFreelancers
Thanks for your comment. I am unable to take on projects. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
How to get all photos from google form to excel? I can use "=img" from spreadsheet but when i download and open it with excel, the picture won't show
HI i am not sure as I have not tried that yet. Thank you for your Likes, Shares & Comments. It really helps.
Great job Randy.
How can expand to a range (not a cell)?
Hi and thanks you can modify a range into an array and use that to sync from Excle to GS and back to Excel. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@@ExcelForFreelancers Hi Dear, I would like to request you to make a video or atleast provide the codes for importing data for a specific range from macro enabled Excel to Google sheet. Thanks for this video
Hello, Is it possible to share your code for pulling the data for a specific range (and not only for a specific cell) of cells in a worksheet or a whole worksheet from macro enabled MS Excel (2016 or 365) sheet and loading dynamic data by importing from a third pary website to GS ? I didn't find out anything in your videos as well as in your FB portal. Thanks in advance. Atleast a reply (either YES or NO) will be appreciated.
How rude of me, I was so wrapped up in trying to get it to work at 1am UK time I didn’t even thank you for all your efforts and well, GENIUS way of solving one of life’s issues.. Thank you 🙏🏽.
I copied the code from webhooks and pasted it as you mentiond but, when I go to save work on excel it wants to know what to save file as. What should it be saved as? Unicode Text?
Ah Saving as XLSM. but it still won't "Successfuly..."
Solved, Link Sheets before you do it. Nice!
Hi Jonny, thanks so much. I am glad you were able to find a solution. Most of my videos are intermediate to advanced Excel VBA.
You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount
Good Afternoon, I ask you how to transfer visual basic code to other users. please help me.
HI and thanks. I have a training in which you can share & sync your macro-enabled workbook with anyone in the world here: czcams.com/video/aKV5seZmiBs/video.html
This is great and all, but it only updates one cell at a time. It's impossible to copy/paste data to the excel file or change more than one cell at a time (like deleting values from 2+ cells at one time) or pasting 2+ cells worth of data at one time. Any way to change this or account for multiple cells being updated at the same time?
HI and thanks for your comment. I am only aware of being able to change once cell at a time however for more than one cell you can share the Google Sheet as a public link then use that links as a connection in Excel, which will replace, or update, the data in Excel with all or new lines of data. I hope this helps and thanks so much.
Right on :)
Thank you very much. I do appreciate that Kehler
Good video 💖
Thanks so much Rofiqul
this video is awesome, i wish i could give more than one like for it, thank you so much.
I have one question and did not find the answer to it in the replies below...
i noticed, since we use "update a cell" we cant really copy paste more than one cell at a time on excel with it updating on google , which kinda makes sense.
i wonder if there is a way to do that? i tried to replicate this with "get range" but failedmiserably. when i am pasting 2 cells at the same time the macro naturally fails it it wants to send only one cell....
Any answer would be much appreciated , felix
Hi there may be a way to do that since the Google API does allow range changes. There is only so much I can add in a 1 hour video however you can explore it to see if it works. I hope this helps and thanks so much.
Sir you are awesome
Love from india
Thank you so very much, I really appreciate that
If Google sheets changes to empty cell, the text file will be empty
and causes error @ "Line Input #1, CellValue".
HI and thanks for your feedback David, You can write an If/Then statement or error trapping to clear the cell on error to avoid the debugging to appear. I hope this helps and thanks very much.
Can anyone explain how to make this work for the Quiz Randy created? I tried Zapier and it worked but it isnt free, So I would like to know how to set integromat up to do the same thing. I just do not understand it. Or IF anyone knows how to do it with his other video that simply uses google forms? HELP PLEASE.... Other sites (facebook or Excel forums seem to not generate any ideas) Thanks
Hi and thanks if you see my recent videos (last week) on PDF to Invoice you can see how we can cerate text files using Dropbox and Integromat.
I hope this helps and thanks so much.
Excellent
Thank you! Cheers! :)
God bless you thank you so much
Thank you so very much, I really appreciate that.
Can make excel when we sell a product,this product will reduce from orignal products??
Hi yes you can search my channel for "Inventory" as I have many videos to teach you this. Thank you for your Likes, Shares & Comments. It really helps.
Thank..
really appreciate for your skill, but i want to know how it can update if i delete from excel ?
HI and thanks as long as you delete a single cell at at time. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
It's a great video & help alot. Kindly prepare video to have data from Google chrome into excel sheets with excel vba or to control Google chrome from Excel vba. I tried my best but am not a pro & you can do it with ease sir
HI and thanks Google Chrome is a browser, so I am not sure what you are trying to achieve. Thanks for your comment.
@@ExcelForFreelancers sir I want to control Google chrome from Excel so that scraping can be done
There are tons of videos already on web scraping just search "Web Scraping" and you will find thousands of great videos. Thanks verymuch.
Great & helpful video....But when I delete any cell it gives me run time error, how to avoid this bug? Thanks a lot
Hi Kayyali, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Integromat will ask for a suscription using this connection?
No subscription is needed. Sign up is free. I hope this helps and thanks.
Sir, may I ask how do I sum up items in excel using uipath and auto fill into Google Sheet?
HI and thanks you can use the SUM formula to sum in Excel. For your excel-related questions please post them in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 40,000 Members who would love to help you with this. Thanks so much.
@@ExcelForFreelancers Thank you Sir!