How To Create A Real-Time Sync Between Excel & Google Sheets Without Excel Add-Ins [Free Download]

Поділитися
Вставка
  • Опубліковано 5 гру 2024

КОМЕНТАРІ • 476

  • @ExcelForFreelancers
    @ExcelForFreelancers  День тому

    ⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

  • @alkolff1031
    @alkolff1031 4 роки тому +3

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      Thanks so much Al, I am so glad I can help and I always appreciate your comments.

    • @johnsonben1403
      @johnsonben1403 2 роки тому +1

      Being great full to #drogoco you have put a smile on my face with just your herbs to cure hsv.

  • @joemanflyer2001
    @joemanflyer2001 5 місяців тому

    I used google sheets on my iPhone and it worked great for use as a baseball manager. Great tips in this video

  • @Emil-sr4dw
    @Emil-sr4dw Рік тому +2

    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 ?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

  • @sudarshanshewale5466
    @sudarshanshewale5466 2 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @kailashsoni676
    @kailashsoni676 Рік тому +1

    Sir you are awesome
    Love from india

  • @omarsaeed531
    @omarsaeed531 2 роки тому +1

    You really made me love excel

  • @Doumir
    @Doumir Рік тому +1

    Good Job. Thank you

  • @maychristinesison5250
    @maychristinesison5250 2 роки тому +1

    Hello! I really love your videos, this is just to adk if it is possible to use other platform instead of dropbox?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @Mr.Ammaro
    @Mr.Ammaro 4 роки тому +9

    Really amazing, from new to newest , ( ALLAH ) god bless you friend ...

  • @narasimhanandam7858
    @narasimhanandam7858 3 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      Hi and thanks. I also got your email on this question as well. Please check your email for the response. Thank you.

  • @abdelazizserrari580
    @abdelazizserrari580 8 місяців тому +1

    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 .🙏

    • @ExcelForFreelancers
      @ExcelForFreelancers  8 місяців тому

      Hi and thanks, yes you can do that for sure. Thank you for your Likes, Shares & Comments. It really helps.

    • @abdelazizserrari580
      @abdelazizserrari580 8 місяців тому +1

      Can you help me in this way, thank you@@ExcelForFreelancers

    • @ExcelForFreelancers
      @ExcelForFreelancers  8 місяців тому

      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.

  • @falaknagar8080
    @falaknagar8080 6 місяців тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  6 місяців тому

      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.

  • @ronnyshubinsky622
    @ronnyshubinsky622 Рік тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

  • @stafadriaensen4496
    @stafadriaensen4496 Рік тому +1

    Fantastic. But is there alsof a way to synchronise whole sheets that are weekly updated?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

    • @stafadriaensen4496
      @stafadriaensen4496 Рік тому +1

      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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

  • @MichaelKopanaslike
    @MichaelKopanaslike 2 роки тому +1

    That must be the most useful video i've ever seen . Thank you so much

  • @sugoutbound6674
    @sugoutbound6674 2 роки тому +1

    good job sir, sir please make a vba excel tutorial that is connected to google data studio in real time

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      Hi and thanks so much for your suggestion. I am going to look into it. Seems intersting. Much appreciated.

  • @jepschannel8450
    @jepschannel8450 Рік тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому +1

      HI and thanks very much. Yes this should work in any shared drive folder. I hope this helps and thanks so much.

  • @wasifabbas8160
    @wasifabbas8160 4 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      HI and thanks Google Chrome is a browser, so I am not sure what you are trying to achieve. Thanks for your comment.

    • @wasifabbas8160
      @wasifabbas8160 4 роки тому +1

      @@ExcelForFreelancers sir I want to control Google chrome from Excel so that scraping can be done

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      There are tons of videos already on web scraping just search "Web Scraping" and you will find thousands of great videos. Thanks verymuch.

  • @infojani1522
    @infojani1522 Рік тому +1

    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:)

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

  • @alexdejavu1
    @alexdejavu1 4 роки тому +1

    thanks, it works when add data cell by cell to excell. . how is possible to add more data(copy/paste) in excell and work?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Hi and thanks you can use Ranges as well via the Integromat functions. I hope this helps and thanks so much.

  • @peterdeak4375
    @peterdeak4375 2 роки тому +1

    Very useful, thank you.
    I have a question, how much will it change if I want to use it on multiple worksheets?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому +1

      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.

    • @peterdeak4375
      @peterdeak4375 2 роки тому +1

      @@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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @tommyexceltricks7665
    @tommyexceltricks7665 2 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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

  • @hazem9325
    @hazem9325 Рік тому +1

    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

    • @hazem9325
      @hazem9325 Рік тому

      I use mac

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

  • @jawadkhan4786
    @jawadkhan4786 4 роки тому +1

    Its amazing as always...
    Please make a brief video on syncing Microsoft excel sheets.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      Hello Jawad, thanks so much for your comment. i will add it to my list. Much appreciated.

  • @andrescarvajal9888
    @andrescarvajal9888 Рік тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

  • @isaacnyachae9423
    @isaacnyachae9423 4 роки тому +1

    Randy you are a blessing! God bless you

  • @simplejuan
    @simplejuan 8 місяців тому +1

    Thank you so much. This is a great tutorial!

    • @ExcelForFreelancers
      @ExcelForFreelancers  8 місяців тому

      For sure, you are very welcome and I am happy to help and share

  • @saxena1955
    @saxena1955 3 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @givemeapps123
    @givemeapps123 Рік тому +1

    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)?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

    • @givemeapps123
      @givemeapps123 Рік тому +1

      @@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)

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

    • @givemeapps123
      @givemeapps123 Рік тому

      @@ExcelForFreelancers Hi, is there another option to upload? As, like I said, I am not on facebook.

  • @haiderrizwan5
    @haiderrizwan5 2 роки тому +1

    Take ti, enjoy it most of all and results will follow

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      Thank you for your Likes, Shares & Comments. It really helps Haiderrizwan5

  • @expat2010
    @expat2010 3 роки тому +1

    Very nice. Thank you. And thanks for no music! :)

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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

  • @seychelles44
    @seychelles44 2 роки тому +1

    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?

    • @seychelles44
      @seychelles44 2 роки тому +1

      Ah Saving as XLSM. but it still won't "Successfuly..."

    • @seychelles44
      @seychelles44 2 роки тому +1

      Solved, Link Sheets before you do it. Nice!

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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

  • @abdofares91
    @abdofares91 4 місяці тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 місяці тому

      Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 2 роки тому +1

    That's amazing. Thanks Randy

  • @T_h_e_Best
    @T_h_e_Best 3 роки тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

    • @T_h_e_Best
      @T_h_e_Best 3 роки тому +1

      @@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(((

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @osamasaid8476
    @osamasaid8476 4 роки тому +1

    You are a great teacher

  • @ekowanin
    @ekowanin 3 роки тому +1

    You just aided me in my final project thanks!!

  • @enriqueblanco8784
    @enriqueblanco8784 3 роки тому +1

    Thanks for the content you create... thanks !!!. By the way: Can Google Sheets open (and run seamlessly) excel files with Macros?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

  • @talebbagazi1435
    @talebbagazi1435 2 роки тому +1

    is it secure fr our data? or going on public?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      Hi and this can be secured for your data. I hope this helps and thanks so much.

  • @findthetruth3021
    @findthetruth3021 3 роки тому +1

    Very nice but how can we do it vise versa from online excel to Google sheet? Is there any ways, thanks in advance.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

    • @findthetruth3021
      @findthetruth3021 3 роки тому +1

      @@ExcelForFreelancers without your video guidance, it is really hard to do that. Thanks for your prompt response.

  • @risandiusman6086
    @risandiusman6086 3 роки тому +1

    Hallo Mr. Randy, What is meant by 1000 operations and 100mb of data transfer on Integromat service? Thank you.
    God bless you.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

  • @RemyCrusio
    @RemyCrusio 3 роки тому +1

    Hello from the Netherlands: How do you do this with Zapier?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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

  • @ajinuriansyah1597
    @ajinuriansyah1597 3 роки тому +1

    really appreciate for your skill, but i want to know how it can update if i delete from excel ?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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

  • @ronilobongga81
    @ronilobongga81 3 роки тому +1

    Hi sir, I'm from Philippines. Thank you for this tutorial. Love it. I already done subcribing and hitting the bell. God bless.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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

  • @Mohdkayyali
    @Mohdkayyali 2 роки тому +1

    Great & helpful video....But when I delete any cell it gives me run time error, how to avoid this bug? Thanks a lot

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому +1

      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.

  • @chavelooo33
    @chavelooo33 2 роки тому +1

    I love everything you. thanks for sharing

  • @masbromw3880
    @masbromw3880 Місяць тому +1

    Can you make new tutorial with new view integromat?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Місяць тому +1

      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.

  • @bartfonteyne9237
    @bartfonteyne9237 4 роки тому +3

    As usual again a great training. I really appreciate the work you put in every time :)

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      Thank you so very much, I am so glad you liked the training Bart.

    • @johnsonben1403
      @johnsonben1403 2 роки тому

      Being great full to #drogoco you have put a smile on my face with just your herbs to cure hsv.

  • @jommyknots9091
    @jommyknots9091 8 місяців тому +1

    It is possible when the source file "insert new sheets" then destination file also automatically "insert new sheets" too ?

    • @ExcelForFreelancers
      @ExcelForFreelancers  8 місяців тому

      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.

    • @jommyknots9091
      @jommyknots9091 8 місяців тому +1

      @@ExcelForFreelancers thank you ♥️

  • @ann0ynim0us
    @ann0ynim0us Рік тому

    hi, Sheet1 nailed it in this video, but how do we include syncing Sheet2 and subsequent Sheet numbers as well? thanks

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

    • @ann0ynim0us
      @ann0ynim0us Рік тому +1

      @@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 😊

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      Excellent. So glad you got it figured out. Thank you for your Likes, Shares & Comments. It really helps.

  • @alexrakich6662
    @alexrakich6662 2 роки тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @MahabubAlam-ek8be
    @MahabubAlam-ek8be 2 роки тому +1

    This is absolutely amazing advice

  • @diegomunozguzman9334
    @diegomunozguzman9334 Рік тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      Hi and thanks, what specific issues are you facing with the scenario?

  • @thangnguyenhuu556
    @thangnguyenhuu556 3 роки тому +1

    Wow that is what I need, thanks so much

  • @bonalvero
    @bonalvero 2 роки тому +1

    Nice sir. I have a question, does it sync also the formula or just the result only of the formula used?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @triplem9777
    @triplem9777 4 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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.

  • @minhngocnguyen5029
    @minhngocnguyen5029 4 роки тому +1

    Great job Randy.
    How can expand to a range (not a cell)?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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

    • @jayantakumarsarkar3689
      @jayantakumarsarkar3689 4 роки тому +1

      @@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

    • @stockmarketsinindia
      @stockmarketsinindia 4 роки тому

      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.

  • @AronnPalmer
    @AronnPalmer 3 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @danielleredmanalang3501
    @danielleredmanalang3501 Рік тому +1

    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.

    • @danielleredmanalang3501
      @danielleredmanalang3501 Рік тому +1

      How could I do it without doing the manual deletion using backspace?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

    • @danielleredmanalang3501
      @danielleredmanalang3501 Рік тому +1

      @@ExcelForFreelancers thank you

  • @abdulsajjadgalib
    @abdulsajjadgalib 3 роки тому +1

    Amazing video sir,

  • @raymondreyes8782
    @raymondreyes8782 4 роки тому +1

    Good Afternoon, I ask you how to transfer visual basic code to other users. please help me.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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

  • @piotrpawlak1497
    @piotrpawlak1497 4 роки тому +2

    Great idea, great workmanship
    .
    Thank you very much.

  • @ashbbeyamo6946
    @ashbbeyamo6946 2 роки тому +1

    hello just want to link the total of a column from excel to google sheet..how to do it?

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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

    • @ashbbeyamo6946
      @ashbbeyamo6946 2 роки тому +1

      @@ExcelForFreelancers thank you for your reply...

  • @rowaterbahriyatown7626
    @rowaterbahriyatown7626 2 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @magdabiedzka3268
    @magdabiedzka3268 3 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @ProjeAdam.
    @ProjeAdam. 3 роки тому +1

    woow really awesome

  • @graceguntren5269
    @graceguntren5269 3 роки тому +1

    Will this work on a Mac?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @zaydasmal518
    @zaydasmal518 2 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @Dominic-bj3ls
    @Dominic-bj3ls Рік тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому +1

      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.

    • @Dominic-bj3ls
      @Dominic-bj3ls Рік тому +1

      @@ExcelForFreelancers Amazing. I began catching and patching some bugs, and would love to share it to a board or forum somewhere?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

    • @Dominic-bj3ls
      @Dominic-bj3ls Рік тому +1

      ​@@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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

  • @fajrinji2689
    @fajrinji2689 3 роки тому +1

    can the fingerprint reader be synchronized with vba excel?
    Reply please I need a help

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

    • @fajrinji2689
      @fajrinji2689 3 роки тому +1

      @@ExcelForFreelancers can you make a video tutorial? because I'm still confused, because the input doesn't look like a barcode scanner

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      HI and thanks. I will do my best to get that done in the near futre.

  • @setiamj
    @setiamj 4 роки тому +1

    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?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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.

  • @mostainbillah
    @mostainbillah 3 роки тому +1

    very good the tutorial

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      Thank you! Cheers!

    • @mostainbillah
      @mostainbillah 3 роки тому +1

      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

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

  • @TanJunLe
    @TanJunLe 4 роки тому +1

    will formatting in GS transfer to Excel? Also it will not work without the Integromat right?

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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.

    • @TanJunLe
      @TanJunLe 4 роки тому +1

      @@ExcelForFreelancers Thanks, it really help. Maybe you could help with adding the code for formatting please? Thanks!

  • @NdoroBambung
    @NdoroBambung 8 місяців тому +1

    what if we delete cell values ​​in excel? will they also be deleted in google sheets?

    • @ExcelForFreelancers
      @ExcelForFreelancers  8 місяців тому

      Hi and thanks. Yes that is correct. I hope this helps and thanks so much.

  • @lehongquan6772
    @lehongquan6772 Рік тому +1

    Hi, it seems Integromat not working anymore, can you check it please!

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому +1

      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.

  • @dorlagrant4079
    @dorlagrant4079 4 роки тому +1

    Thanks Randy.

  • @ghifery1
    @ghifery1 3 роки тому +1

    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..

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

    • @ghifery1
      @ghifery1 3 роки тому +1

      Thank you..

  • @raymondreinhard2292
    @raymondreinhard2292 4 роки тому +2

    Cant wait this vid

  • @raymondreinhard2292
    @raymondreinhard2292 4 роки тому +1

    u r awesome sir. Thank in advance u made my day👍👍

  •  3 роки тому

    March 2021 and still working, great! Thanks a lot

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      That is great to here. thanks so much.

    •  3 роки тому +1

      @@ExcelForFreelancers Im having a "run-time error 13 type mismatch" error when paste more than 1 value at the time :/

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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

  • @Privolti
    @Privolti 4 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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

    • @Privolti
      @Privolti 3 роки тому

      @@ExcelForFreelancers thanks so much for your response
      Will join the group 👍

    • @Privolti
      @Privolti 3 роки тому

      @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?

  • @rofiqulislam7544
    @rofiqulislam7544 2 роки тому +1

    Good video 💖

  • @gondordx4174
    @gondordx4174 3 роки тому +1

    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 !

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @susiehui4938
    @susiehui4938 4 роки тому +1

    Love this training!

  • @thehgamers
    @thehgamers Рік тому +1

    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…

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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.

  • @gavin0803
    @gavin0803 3 роки тому +1

    Thank u

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      For sure, you are very welcome

    • @gavin0803
      @gavin0803 3 роки тому +1

      @@ExcelForFreelancers But if I have lots of data to sync. >.

  • @cyril_leonel4713
    @cyril_leonel4713 3 роки тому +2

    Can it sync without having to use 3rd party apps (integromat) ?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @liquidwawan7114
    @liquidwawan7114 3 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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/

  • @graceguntren5269
    @graceguntren5269 3 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      Hi Grace, yes it is possible to use the .Formula instead of the .value. I hope this helps and thanks so much.

    • @graceguntren5269
      @graceguntren5269 3 роки тому +1

      @@ExcelForFreelancers this worked thank you so much!

  • @abdullahquhtani4247
    @abdullahquhtani4247 4 роки тому +2

    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 🙏

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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.

  • @sameeradasanayake1712
    @sameeradasanayake1712 2 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  2 роки тому

      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.

  • @binhbinh3448
    @binhbinh3448 Рік тому +1

    Sir, How can i update the real time column from excel into gg sheet, what do i have to change ?

    • @ExcelForFreelancers
      @ExcelForFreelancers  Рік тому

      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

  • @YTUBEUNI
    @YTUBEUNI 3 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому

      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.

  • @mumbaitiger
    @mumbaitiger 4 роки тому +1

    Love this code and training. Just Awesome

  • @hyl443
    @hyl443 3 роки тому +1

    Sir, may I ask how do I sum up items in excel using uipath and auto fill into Google Sheet?

    • @ExcelForFreelancers
      @ExcelForFreelancers  3 роки тому +1

      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.

    • @hyl443
      @hyl443 3 роки тому +1

      @@ExcelForFreelancers Thank you Sir!

  • @rezayoun6571
    @rezayoun6571 4 роки тому +1

    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.

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому

      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.

  • @felixwagner86
    @felixwagner86 4 роки тому +1

    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

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      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.

  • @melkamzenatube8000
    @melkamzenatube8000 4 роки тому +1

    God bless you thank you so much

  • @pedropablogarciapaez9926
    @pedropablogarciapaez9926 4 роки тому +1

    There is any chance to connect Excel as API Database to a Website instead of Google Sheets using Integromat??

    • @ExcelForFreelancers
      @ExcelForFreelancers  4 роки тому +1

      Absolutely. Integromat has a database as well. I will make a video on this in the future. I hope this helps and thanks.