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
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: ua-cam.com/video/f_1HsR9305I/v-deo.html
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.
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.
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 .🙏
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.
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 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
Hi adn thanks very much. You can save entire sheets in a local Google Drive folder which will also be uploaded to your Google drive and can be opened in Google drive. I hope this helps and thanks so much.
Yes I know, but I'm trying to automate the proces from in excel: when data are replaced by new data, then send it to webhook and from there to googlesheets. The reason: I'm trying to embed data in a webform. But whith the excel file (stored in onedrive) I can not hide the option to see the URL and to download (only in onedrive for business). So I want to use googlesheets.
Hi and thanks, There are more options, however if you can add your question in 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.
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?
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. 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.
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.
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
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
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
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?
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.
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.
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
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?
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
Thanks for the video. I have subscribed to the channel. However, the VBA code gives me an error when I run it. Can you please send me the code you have presented in the video?
Greate video!!! But i have a qusstions, how do this for between local excel file, one drive and sharepoint List? And afterward how those all cell changes shown in microsoft teams chanal list? I think this greate idea for a new video lessons, isn't it?
Hi and thanks I have a training on Sharing & Syncing Excel files with a shared folder here: ua-cam.com/video/aKV5seZmiBs/v-deo.html I hope this helps and thanks so much.
@@ExcelForFreelancers ,yes, i saw it- and this is between two excel files.... But I'm about how to connect and sync table with tasks ( sheet 3) in my local excel file with a list in Microsoft Teams. For example: if you change a cell in a table on sheet3, it automatically changes in the list in Teams and vice versa! this is really a challenge, as there is no more information on it, unfortunately(((
HI and thanks very much. I have not tried this with Teams, however every single user, and every single computer must have a different and duplicate Excel application. Only the data is shared between the files and the macros take care of the sync work. I hope this helps and thanks so much.
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: ua-cam.com/video/aKV5seZmiBs/v-deo.html I hope this helps and thanks so much.
Hi and thanks for your comment. This can be achieved through scrips or you can use Excel's integration with Integromat which would work just fine. I hope this helps and thanks so much.
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.
Hi and thanks you would follow the same procedure by connecting the appropriate applications and authorizations then create a workflow with triggers on both ends. 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 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
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
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.
Hi and thanks so much for your comment. Although the name has changed from Integromat to Make, all of the features inside are nearly the same. I hope this helps and thanks so much.
Hi and thanks it may be possible, if there is a trigger on Make > Google Sheets for "Sheet Inserted" You can check that out. I hope this helps and thanks so much.
Hi and thanks so much. If you have multiple sheets, you will want to put the sheet name into a variable and then pass that variable through Make (formerly Integromat), so at the point you select a sheet name inside the automation, you will use the variable. Just make sure the Google sheet names and the Excel sheet names are exactly the same. 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 hey thanks for the reply, I figured out the easiest way was to copy and paste the same code for each sheet in the VB Editor on Excel, then the same sheet on Google Sheets updated as well, it works brilliantly now 😊
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, thanks for your tutorial. Now there is new options in MAKE is there any chance you could update this tutorial? Or help us out with an script, thanks. Let me know if i can write you via mail
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.
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 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.
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.
Thank you for this helpful tutorial. However upon trying to delete data entered in excel by highlighting the range or data that I would like to delete and press the delete button on the keyboard, the data still remains on the google sheet.
Hi Daniel, you could reprogram the Delete key using the SendKeys command and run a macro to delete the entire row. The Data in google sheets would remain as it only syncs when a single cell is changed.d
HI and thanks. I have a training in which you can share & sync your macro-enabled workbook with anyone in the world here: ua-cam.com/video/aKV5seZmiBs/v-deo.html
Hi and thanks you can run a change event that has any change within a column to change in Google. If you have a formula in Google as well, then any change within the sum range will automatically total in google as well. 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, 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.
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.
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.
I wonder if there is better error handling for this. What happens if you make batch changes? What happens if those changes are made with Macros? What happens there are sync conflicts, how would you merge them?
Absolutely! I Create these templates in just a day or so, and certainly, there are a lot of ways we can handle errors better. These templates are often just a starting point for larger applications. Please feel free to download the template using the link in the description and customize it however you like. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. Feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to hear from you. Thanks so much.
@@ExcelForFreelancers Ahh, I don't have facebook, that's a shame. But... heres my v003 for the modules .bas. It mainly handles GSheets_to_Excel deletions. ``` Option Explicit Sub RunSync() Application.OnTime DateAdd("s", 3, Now), "SyncFromGoogle" End Sub Sub SyncFromGoogle() Dim FileName As String, FolderPath As String, FilePath As String, CellValue As String, CellAdd As String, SheetName As String FolderPath = "C:\Users\Dom\Dropbox\ExcelSync\" FileName = Dir(FolderPath & "*.txt") Do While Len(FileName) > 0 'Start Of Loop FilePath = FolderPath & FileName Open FilePath For Input As #1
'Check if there is data in the file, if not, set CellValue to an empty string If Not EOF(1) Then Line Input #1, CellValue Else CellValue = "" End If
Close #1 SheetName = Left(FileName, InStr(FileName, "-") - 1) 'Sheet Name CellAdd = Mid(FileName, InStr(FileName, "-") + 1, InStr(FileName, ".") - InStr(FileName, "-") - 1) 'Write the CellValue to the cell, even if it is an empty string ThisWorkbook.Sheets(SheetName).Range(CellAdd).Value = CellValue Kill (FilePath) FileName = Dir() 'Clears out the current file name Loop RunSync 'Run again End Sub ``` Here's the full recorded feature logs. - Excel_to_GSheets: - single overwrites work - single deletions work - single ctrlV works - changes in Excel are reflected to GSheets within miliseconds - GSheets_to_Excel: - single overwrite works - single deletions work (since v003) - single ctrlV works - changes in GSheets are reflected to Excel within six seconds Current limitations are... - ! group pasting does NOT register to dropbox - ! consecutive fast edits UNSTABLE - ! back of envelope calculation required for 1,000 operations countdown %% Feel free to let me know if it's any good. Or if there's any improvement implementations I can make to handle group pasting, or shortening execution time in GSheets_to_Excel.
Hi and thanks very much. Please check out my change log video in which all changes are saved and can be reversed here: Part 1: ua-cam.com/video/6TnxPvLz_44/v-deo.html Part 2: ua-cam.com/video/fE15W72vnEE/v-deo.html I hope this helps and thanks so much.
HI and yes, The fingerprint reader stores and extracts an ID # for every fingerprint. When you use this reader as a USB interface it can automate that ID to load your record. I hope this helps and thanks so much.
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.
As easy as you can do it, but I can't do it as easily, if I could get an example file with Excel code, But maybe I could be successful, you can help if you want by uploading an example file, thanks , mostaincad@gmail.com
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.
Hi and thanks you can update many cells at a single time using the Range feature in Integromat & google sheets as long as you have the upper left cell and the lower right cell. I hope this helps and thanks so much.
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
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
@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 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.
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/
Is it possible to use Worksheet Change when my excel file also contains formulas? I got the code to run but it does not move the formulas from my excel file to google sheets.
That’s really great But! It’ll be greater if we use APPScript instead of using third party services like integromat and applications like Dropbox you used in this tutorial. There are a lot of free APPScript that post and get data as JSON and can be modified to be used as medium between Excel and Google sheets. I hope that you could adopt this idea and make a tutorial in the future explaining this solution. Thank you 🙏
Hello Abdullah thanks for much. The script is the easy part, however we still need a 3rd party tool to get OAuth on sites such as Google & Dropbox. Thank you for your comment. Much appreciated.
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.
Hi and thanks very much. You can do a cell by cell which is quick, otherwise you can copy and paste. 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
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: ua-cam.com/video/YuCrEWU2Tm0/v-deo.html I hope this helps and thanks so much.
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.
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.
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.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
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.
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
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: ua-cam.com/video/f_1HsR9305I/v-deo.html
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.
Sir you are awesome
Love from india
Thank you so very much, I really appreciate that
You really made me love excel
That is great to hear Omar 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.
Really amazing, from new to newest , ( ALLAH ) god bless you friend ...
Thank you very much. I do appreciate that.
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.
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.
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: ua-cam.com/video/EA_0p_9E8u0/v-deo.html
I hope this helps and thanks so much.
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
Fantastic. But is there alsof a way to synchronise whole sheets that are weekly updated?
Hi adn thanks very much. You can save entire sheets in a local Google Drive folder which will also be uploaded to your Google drive and can be opened in Google drive. I hope this helps and thanks so much.
Yes I know, but I'm trying to automate the proces from in excel: when data are replaced by new data, then send it to webhook and from there to googlesheets. The reason: I'm trying to embed data in a webform. But whith the excel file (stored in onedrive) I can not hide the option to see the URL and to download (only in onedrive for business). So I want to use googlesheets.
Hi and thanks, There are more options, however if you can add your question in 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.
That must be the most useful video i've ever seen . Thank you so much
Glad it was helpful and thanks so much.
good job sir, sir please make a vba excel tutorial that is connected to google data studio in real time
Hi and thanks so much for your suggestion. I am going to look into it. Seems intersting. Much appreciated.
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.
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.
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.
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.
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.
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
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
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.
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.
Randy you are a blessing! God bless you
Thank you so very much, I really appreciate that Isaac
Thank you so much. This is a great tutorial!
For sure, you are very welcome and I am happy to help and share
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.
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.
Take ti, enjoy it most of all and results will follow
Thank you for your Likes, Shares & Comments. It really helps Haiderrizwan5
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
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
Thanks for the video. I have subscribed to the channel. However, the VBA code gives me an error when I run it. Can you please send me the code you have presented in the video?
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
That's amazing. Thanks Randy
For sure, you are very welcome Syed
Greate video!!! But i have a qusstions, how do this for between local excel file, one drive and sharepoint List? And afterward how those all cell changes shown in microsoft teams chanal list? I think this greate idea for a new video lessons, isn't it?
Hi and thanks I have a training on Sharing & Syncing Excel files with a shared folder here: ua-cam.com/video/aKV5seZmiBs/v-deo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers ,yes, i saw it- and this is between two excel files.... But I'm about how to connect and sync table with tasks ( sheet 3) in my local excel file with a list in Microsoft Teams. For example: if you change a cell in a table on sheet3, it automatically changes in the list in Teams and vice versa! this is really a challenge, as there is no more information on it, unfortunately(((
HI and thanks very much. I have not tried this with Teams, however every single user, and every single computer must have a different and duplicate Excel application. Only the data is shared between the files and the macros take care of the sync work. I hope this helps and thanks so much.
You are a great teacher
Glad you think so and thanks so much Osama
You just aided me in my final project thanks!!
Great. I am happy i could help Ekow
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: ua-cam.com/video/aKV5seZmiBs/v-deo.html
I hope this helps and thanks so much.
is it secure fr our data? or going on public?
Hi and this can be secured for your data. I hope this helps and thanks so much.
Very nice but how can we do it vise versa from online excel to Google sheet? Is there any ways, thanks in advance.
Hi and thanks for your comment. This can be achieved through scrips or you can use Excel's integration with Integromat which would work just fine. I hope this helps and thanks so much.
@@ExcelForFreelancers without your video guidance, it is really hard to do that. Thanks for your prompt response.
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.
Hello from the Netherlands: How do you do this with Zapier?
Hi and thanks you would follow the same procedure by connecting the appropriate applications and authorizations then create a workflow with triggers on both ends.
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
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
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
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.
I love everything you. thanks for sharing
Thank you so very much, I really appreciate that Diego.
Can you make new tutorial with new view integromat?
Hi and thanks so much for your comment. Although the name has changed from Integromat to Make, all of the features inside are nearly the same. I hope this helps and thanks so much.
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.
It is possible when the source file "insert new sheets" then destination file also automatically "insert new sheets" too ?
Hi and thanks it may be possible, if there is a trigger on Make > Google Sheets for "Sheet Inserted" You can check that out. I hope this helps and thanks so much.
@@ExcelForFreelancers thank you ♥️
hi, Sheet1 nailed it in this video, but how do we include syncing Sheet2 and subsequent Sheet numbers as well? thanks
Hi and thanks so much. If you have multiple sheets, you will want to put the sheet name into a variable and then pass that variable through Make (formerly Integromat), so at the point you select a sheet name inside the automation, you will use the variable. Just make sure the Google sheet names and the Excel sheet names are exactly the same.
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 hey thanks for the reply, I figured out the easiest way was to copy and paste the same code for each sheet in the VB Editor on Excel, then the same sheet on Google Sheets updated as well, it works brilliantly now 😊
Excellent. So glad you got it figured out. Thank you for your Likes, Shares & Comments. It really helps.
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.
This is absolutely amazing advice
Thank you so very much, I really appreciate that Mahabub
Hi, thanks for your tutorial. Now there is new options in MAKE is there any chance you could update this tutorial? Or help us out with an script, thanks. Let me know if i can write you via mail
Hi and thanks, what specific issues are you facing with the scenario?
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. :)
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.
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.
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.
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.
Thank you for this helpful tutorial. However upon trying to delete data entered in excel by highlighting the range or data that I would like to delete and press the delete button on the keyboard, the data still remains on the google sheet.
How could I do it without doing the manual deletion using backspace?
Hi Daniel, you could reprogram the Delete key using the SendKeys command and run a macro to delete the entire row. The Data in google sheets would remain as it only syncs when a single cell is changed.d
@@ExcelForFreelancers thank you
Amazing video sir,
Thank you so very much, I really appreciate that Abdul
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: ua-cam.com/video/aKV5seZmiBs/v-deo.html
Great idea, great workmanship
.
Thank you very much.
Thank you very much. I do appreciate that Piotr
hello just want to link the total of a column from excel to google sheet..how to do it?
Hi and thanks you can run a change event that has any change within a column to change in Google. If you have a formula in Google as well, then any change within the sum range will automatically total in google as well.
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 thank you for your reply...
Nice tutorial ... I've got a problem ... when I first used soft soft , there were so tutorial such as Slayer , wNice tutorialch disappeared after I
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 50,000 Members who would love to help you with this. 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.
woow really awesome
Thank you so very much, I really appreciate that Proje
Will this work on a Mac?
Yes this will also work on a Mac however there may need to be adjustments in the code. 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.
I wonder if there is better error handling for this. What happens if you make batch changes? What happens if those changes are made with Macros? What happens there are sync conflicts, how would you merge them?
Absolutely! I Create these templates in just a day or so, and certainly, there are a lot of ways we can handle errors better. These templates are often just a starting point for larger applications. Please feel free to download the template using the link in the description and customize it however you like.
Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Amazing. I began catching and patching some bugs, and would love to share it to a board or forum somewhere?
Hi and thanks so much. Feel free to join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 60,000 Members who would love to hear from you. Thanks so much.
@@ExcelForFreelancers Ahh, I don't have facebook, that's a shame.
But... heres my v003 for the modules .bas. It mainly handles GSheets_to_Excel deletions.
```
Option Explicit
Sub RunSync()
Application.OnTime DateAdd("s", 3, Now), "SyncFromGoogle"
End Sub
Sub SyncFromGoogle()
Dim FileName As String, FolderPath As String, FilePath As String, CellValue As String, CellAdd As String, SheetName As String
FolderPath = "C:\Users\Dom\Dropbox\ExcelSync\"
FileName = Dir(FolderPath & "*.txt")
Do While Len(FileName) > 0 'Start Of Loop
FilePath = FolderPath & FileName
Open FilePath For Input As #1
'Check if there is data in the file, if not, set CellValue to an empty string
If Not EOF(1) Then
Line Input #1, CellValue
Else
CellValue = ""
End If
Close #1
SheetName = Left(FileName, InStr(FileName, "-") - 1) 'Sheet Name
CellAdd = Mid(FileName, InStr(FileName, "-") + 1, InStr(FileName, ".") - InStr(FileName, "-") - 1)
'Write the CellValue to the cell, even if it is an empty string
ThisWorkbook.Sheets(SheetName).Range(CellAdd).Value = CellValue
Kill (FilePath)
FileName = Dir() 'Clears out the current file name
Loop
RunSync 'Run again
End Sub
```
Here's the full recorded feature logs.
- Excel_to_GSheets:
- single overwrites work
- single deletions work
- single ctrlV works
- changes in Excel are reflected to GSheets within miliseconds
- GSheets_to_Excel:
- single overwrite works
- single deletions work (since v003)
- single ctrlV works
- changes in GSheets are reflected to Excel within six seconds
Current limitations are...
- ! group pasting does NOT register to dropbox
- ! consecutive fast edits UNSTABLE
- ! back of envelope calculation required for 1,000 operations countdown
%% Feel free to let me know if it's any good. Or if there's any improvement implementations I can make to handle group pasting, or shortening execution time in GSheets_to_Excel.
Hi and thanks very much. Please check out my change log video in which all changes are saved and can be reversed here:
Part 1: ua-cam.com/video/6TnxPvLz_44/v-deo.html
Part 2: ua-cam.com/video/fE15W72vnEE/v-deo.html
I hope this helps and thanks so much.
can the fingerprint reader be synchronized with vba excel?
Reply please I need a help
HI and yes, The fingerprint reader stores and extracts an ID # for every fingerprint. When you use this reader as a USB interface it can automate that ID to load your record. I hope this helps and thanks so much.
@@ExcelForFreelancers can you make a video tutorial? because I'm still confused, because the input doesn't look like a barcode scanner
HI and thanks. I will do my best to get that done in the near futre.
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.
very good the tutorial
Thank you! Cheers!
As easy as you can do it, but I can't do it as easily, if I could get an example file with Excel code, But maybe I could be successful, you can help if you want by uploading an example file, thanks , mostaincad@gmail.com
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
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!
Hi, it seems Integromat not working anymore, can you check it please!
Hi and thanks so much. Integromat is now Make, so you can find them here; www.Make.com
I hope this helps and thanks so much.
Thanks Randy.
For sure, you are very welcome
what if we delete cell values in excel? will they also be deleted in google sheets?
Hi and thanks. Yes that is correct. I hope this helps and thanks so much.
Nice video, but I want to ask how to update many cells in one sheet at the same time? Because this program can only update single cell..
Hi and thanks you can update many cells at a single time using the Range feature in Integromat & google sheets as long as you have the upper left cell and the lower right cell. I hope this helps and thanks so much.
Thank you..
Cant wait this vid
Thanks so much Raymond
u r awesome sir. Thank in advance u made my day👍👍
Thank you very much. I do appreciate that Raymond
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
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?
Good video 💖
Thanks so much Rofiqul
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.
Love this training!
Thank you very much. I do appreciate that Susie
What if we make a change in excel on a data obtained from google sheets, will this change be reflected in google sheets as well…
Hi and thanks for your comment. Yes, changes in Excel would be displayed in Google sheets as well. I hope this helps and thanks so much.
Thank u
For sure, you are very welcome
@@ExcelForFreelancers But if I have lots of data to sync. >.
Can it sync without having to use 3rd party apps (integromat) ?
Yes it might be possible of you can arrange the Oauth through Google, however I have not tried it myself. I hope this helps and thanks so much.
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/
Is it possible to use Worksheet Change when my excel file also contains formulas? I got the code to run but it does not move the formulas from my excel file to google sheets.
Hi Grace, yes it is possible to use the .Formula instead of the .value. I hope this helps and thanks so much.
@@ExcelForFreelancers this worked thank you so much!
That’s really great But! It’ll be greater if we use APPScript instead of using third party services like integromat and applications like Dropbox you used in this tutorial. There are a lot of free APPScript that post and get data as JSON and can be modified to be used as medium between Excel and Google sheets. I hope that you could adopt this idea and make a tutorial in the future explaining this solution. Thank you 🙏
Hello Abdullah thanks for much. The script is the easy part, however we still need a 3rd party tool to get OAuth on sites such as Google & Dropbox. Thank you for your comment. Much appreciated.
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.
Sir, How can i update the real time column from excel into gg sheet, what do i have to change ?
Hi and thanks very much. You can do a cell by cell which is quick, otherwise you can copy and paste.
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
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:
ua-cam.com/video/YuCrEWU2Tm0/v-deo.html
I hope this helps and thanks so much.
Love this code and training. Just Awesome
Thank you very much. I do appreciate that.
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!
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.
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.
God bless you thank you so much
Thank you so very much, I really appreciate that.
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.