How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone In The World

In this week’s training, I will show you how to create Workbook Sharing & Sync.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
0:37 - Overview
4:00 - Worksheet Design
24:42 - Click Cancel Button
27:33 - Exit Username
29:47 - Click Okay Button
36:00 - User Login
41:07 - User Logout
42:45 - Browse Shared Folder
46:29 - Change Event Worksheet
1:06:49 - Update File

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #workbooksharing #workbookshareandsync #excelvba

[munendra]

Randy.. dear.. you are simply a GEM for folks like us who are trying to lift our skills up onto an advance level. Thanks u once again. God bless you.

[philipchukwu]

Randy is indeed a gift that keeps giving.. Thank you.
Please who else had issues with using this formula? excel doesn't see it as a formula on my practice workbook. please help. =If(INDEX(Password, match(B4, Username, 0), 1)=B5, True, False). seems it has a problem with the match. it's been quite frustrating.

[Sebastien_Frederic]

Hi Randy, Words can't explain how great is this training ! You're Just RANDY, and Thank you ! May God Bless you more! #FromHaiti

[nerenlakhraj]

Simply the best Excel Guru out there. Awesome video and presentation skills and not to mention a workbook to accompany it. Makes VBA worth learning to enhance your skills … thank you Randy. I am sure you all would agree 😊

[setyoufree]

I love your teaching method. Simple and to the point. also love your clean and powerful VBA code.

[michaelsvenson]

Absolutley amazing, this is what we need in our Archery-Club, thank's. Thumbs up....

[darlaemerson]

Hi Randy. Thanks so much for your willingness to share your knowledge! I watched the video "The AMAZING TRICK To Add Different User Security Rights to ANY Excel Sheet and User Login" and created a spreadsheet that will only allow certain users to see certain tabs. However, it doesn't allow more than one user to be in the worksheet at a time which is how I discovered this video! Can I just add the field for syncing, Current User, and Admin on the Admin page and add the Macro for syncing or will I need to update in other places as well? Trying to figure out how to combine these two tutorials🙂. Thanks so much!

[LearnYouAndMe]

One can also use Application.Split to parse string and store individual values in an array. From this array one can get individual values

[anacrob]

Randy GREAT as usual, but unfortunately it is a bit more complex than that. As we discussed I am building a complete version. The strategy is similar but we could give user several possibilities:
1. Delete one line
2. Add a new line
3. What if 2 users make modifications on the same line during the same period?
4. What if 2 users add a new line at the same time?
5. Not a good solution to leave the user the Folder Creating routine handling
6. What about automatic syncing? As you built up in a different lesson, reading the file update time
7. What about the typical delay of Dropbox syncing (measured in about 1.3seconds, depending on connection speed)

Once again a great work, an even better lesson, well explained, but not a usable solution

Ciao, roberto

[carlossaavedra]

Randy a amazing piece of work. I’m a recent subscriber on both, your YT channel and your site so I’m checking on your older tutorials. In this particular one I have one question: This application assumes’ that every user will save his/her changes before closing the WB. That statement comes from the fact that if a user makes some changes but closes the WB without saving the other users will sync changes that are no longer valid. How can with address these sorts of scenarios? Tks in advanced. Regards…

[winfriedwindegger]

Thanks Randy. A really amazing training. And a fantastic functionnality. So useful!

[UlviAhmadov]

Great stuff! One question though... In case one user changes the same cell several times, it is important to have the sequence in right order, so when you sync, not end the wrong value in the cell.

[applewhite]

Hi Randy,
We use 3 computers in my small office.
When the price list is changed, I want them to update the list by sending an e-mail to my other 2 friends.
I discovered the excel for freelancers channel on youtube.
How To Share and Sync Your Macro-Enabled Excel Workbook, from Scratch, With Anyone In The World...
this was the video that exactly what I wanted.
I downloaded the codes and adapted to my workbook.But I have a problem like that..
When I copied the workbook and change it name, it works in my computer. When I send the file to my friends, it didn't work in their computers. The changes that I made didn't seem at others.
We try both Onedrive and Google Drive. Although we setup my onedrive account to all computers, we didn't achieve this.

[SuperHanme]

This is and your other videos are fantastic and have taught me so much, thank you!

[omaraissa]

If we transfer SynText to variant Array with the command like Arr =Split(SynText, ", "), we can easily Extract SheetNAme, Target and Value

[FrankCampbell]

This is and your other videos are fantastic and have taught me so much, thank you! I was really hoping this video would share insights on how to sync Excel tables across multiple workbooks, which would include record changes, adding records to a table, and deleting records from a table. Is this even possible?

[michaelfleming]

Hi Randy, I've learnt a lot from your videos, thanks heaps. I am having trouble with the Share and Sync workbook though. I am using a Google Drive shared folder for the sync files location, but there seems to be quite a delay from when one user updates a cell and the .txt file is generated for other users, to when the other users can see the .txt files. So the problem exists when two users make a change to the same cell within approx 10 seconds of each other. The time gap means that one user get left with outdated data. Hard to explain, but here goes: User1 updates $A$1 and User2 also updates $A$1 lets say 5 seconds later. User1's change is recorded in all users folders in the shared folder (Google Drive). but User2 makes a change also but hasn't yet received the change from User1 (due to Google Drive taking time to sync), so User2 only receives User1's change after his own, meaning that his data is now updated to User1's change (not the latest data). All other users (including User1) receive the change from User2 and are up-to-date. User2 has incorrect data. Any ideas would be greatly appreciated. Thanks, Michael F

[allabouttruckin]

Thank you Mr. Randy it helped me allot. However i have 2 questions. 1. How can we make sync automatically. (No button).
2. I am trying to use this training for POS so in that it may change few columns.
Thank you in advance

[andrewmishler]

Works Awesome, one question I have is, is there a way to use auto sort? without that it is hard to find a contact out of 500 contacts

[Kamy]

Hi, Thank you for all your videos and your enthusiasm. I learn a lot.
If I may suggest at around 1h20 one thing to make it easier was to use an array when you extract the data from text File separated by comma or any separator

Dim SyncText As String, ArrText() As String, SheetName As String, CellAddress As String, CellText As String

SyncText = "Contacts, $G$18, Woodlands Hills" 'comma separated or any separator
ArrText = Split(SyncText, ", ")

SheetName = ArrText(0)
CellAddress = ArrText(1)
CellText = ArrText(2)

Do you agree?

Take care