Back to Browse

Multi-User Excel Workbook Setup | Dropbox + VBA Magic

245.1K views
Jun 12, 2018
59:32

Real-time collaboration in Excelโ€”no shared workbook feature needed. ๐Ÿ”ฅ ๐†๐ž๐ญ ๐“๐ก๐ข๐ฌ + ๐Ÿ’๐ŸŽ๐ŸŽ ๐Ž๐Ÿ ๐“๐ก๐ž ๐๐ž๐ฌ๐ญ ๐„๐ฑ๐œ๐ž๐ฅ ๐“๐ž๐ฆ๐ฉ๐ฅ๐š๐ญ๐ž๐ฌ ๐–๐ข๐ญ๐ก ๐Ÿ๐Ÿ’/๐Ÿ• ๐’๐ฎ๐ฉ๐ฉ๐จ๐ซ๐ญ ๐‡๐ž๐ซ๐ž ๐Ÿ‘‰https://www.excelforfreelancers.com/400-workbook-pack-ytdesc ๐Ÿ’ช ๐€๐‚๐‚๐„๐’๐’ ๐Ÿ“๐ŸŽ๐ŸŽ+ ๐‘๐„๐€๐ƒ๐˜-๐“๐Ž-๐”๐’๐„ ๐•๐๐€ ๐Œ๐€๐‚๐‘๐Ž๐’ ๐–๐ˆ๐“๐‡ ๐Œ๐˜ ๐ƒ๐„๐•๐„๐‹๐Ž๐๐„๐‘๐’ ๐‹๐ˆ๐๐‘๐€๐‘๐˜! ๐Ÿ‘‰ https://www.excelforfreelancers.com/udvl-ytdesc ๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป ๐‰๐Ž๐ˆ๐ ๐Œ๐˜ ๐Œ๐„๐๐“๐Ž๐‘๐’๐‡๐ˆ๐ & ๐’๐“๐€๐‘๐“ ๐๐”๐ˆ๐‹๐ƒ๐ˆ๐๐† ๐ˆ๐๐‚๐Ž๐Œ๐„-๐†๐„๐๐„๐‘๐€๐“๐ˆ๐๐† ๐„๐—๐‚๐„๐‹ ๐€๐๐๐’ ๐Ÿ‘‰ https://www.excelforfreelancers.com/mentorship-program-ytdesc ๐Ÿ‘จโ€๐Ÿ’ผ ๐Œ๐€๐’๐“๐„๐‘ ๐Ÿ-๐‚๐‹๐ˆ๐‚๐Š ๐‘๐„๐๐Ž๐‘๐“๐’ ๐ˆ๐ ๐Œ๐˜ ๐ƒ๐€๐’๐‡๐๐Ž๐€๐‘๐ƒ ๐Œ๐€๐’๐“๐„๐‘๐‚๐‹๐€๐’๐’ ๐Ÿ‘‰ https://www.excelforfreelancers.com/dashboard-masterclass-ytdesc In this weekโ€™s training, Iโ€™ll show you how to create a fully functional multi-user Excel workbook that allows multiple users to work together seamlessly. Youโ€™ll learn how to sync changes, manage user access, and ensure data accuracyโ€”all without using the outdated Share Workbook feature. In This Video, Youโ€™ll Learn: โœ“ How to build a multi-user Excel application โœ“ Sync data from multiple users with live updates โœ“ Prevent conflicts and maintain data integrity โœ“ Use Dropbox or Google Drive for real-time syncing โœ“ Download the free template and build along with the training ๐Ÿ‘‡๐ƒ๐Ž๐–๐๐‹๐Ž๐€๐ƒ ๐“๐‡๐ˆ๐’ ๐–๐„๐„๐Š'๐’ ๐–๐Ž๐‘๐Š๐๐Ž๐Ž๐Š ๐“๐„๐Œ๐๐‹๐€๐“๐„ ๐‡๐„๐‘๐„: https://www.excelforfreelancers.com/sharing-workbooks/ ๐Ÿ›  ๐๐„๐„๐ƒ ๐‡๐„๐‹๐? โžก๏ธ ๐—š๐—ฒ๐˜ ๐—˜๐˜…๐—ฝ๐—ฒ๐—ฟ๐˜ ๐—›๐—ฒ๐—น๐—ฝ ๐—–๐˜‚๐˜€๐˜๐—ผ๐—บ๐—ถ๐˜‡๐—ถ๐—ป๐—ด ๐—ง๐—ต๐—ถ๐˜€ ๐—ข๐—ฟ ๐—”๐—ป๐˜† ๐—ง๐—ฒ๐—บ๐—ฝ๐—น๐—ฎ๐˜๐—ฒ. ๐—ข๐˜‚๐—ฟ ๐——๐—ฒ๐˜ƒ๐—ฒ๐—น๐—ผ๐—ฝ๐—ฒ๐—ฟ๐˜€ ๐—”๐—ฟ๐—ฒ ๐—ฅ๐—ฒ๐—ฎ๐—ฑ๐˜† ๐—ง๐—ผ ๐—”๐˜€๐˜€๐—ถ๐˜€๐˜ ๐—ฌ๐—ผ๐˜‚ ๐—ก๐—ผ๐˜„! https://www.excelforfreelancers.com/CustomsJobs_YTDesc ๐Ÿ˜Ž ๐„๐ฅ๐ข๐ญ๐ž ๐Œ๐ž๐ฆ๐›๐ž๐ซ๐ฌ๐ก๐ข๐ฉ: ๐†๐จ ๐๐ž๐ฒ๐จ๐ง๐ ๐˜๐จ๐ฎ๐“๐ฎ๐›๐ž ๐“๐ฎ๐ญ๐จ๐ซ๐ข๐š๐ฅ๐ฌ ๐–๐ข๐ญ๐ก ๐๐ซ๐ž๐ฆ๐ข๐ฎ๐ฆ ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  & ๐‚๐จ๐š๐œ๐ก๐ข๐ง๐ ๐Ÿ‘‰https://www.excelforfreelancers.com/elite-membership-yt-desc ๐„๐—๐‚๐„๐‹ ๐‚๐Ž๐”๐‘๐’๐„๐’: โ–บ๐— ๐—˜๐—ก๐—ง๐—ข๐—ฅ๐—ฆ๐—›๐—œ๐—ฃ ๐—ฃ๐—ฅ๐—ข๐—š๐—ฅ๐—”๐— : https://www.excelforfreelancers.com/mentorship-program-ytdesc โ–บ๐——๐—”๐—ฆ๐—›๐—•๐—ข๐—”๐—ฅ๐—— ๐— ๐—”๐—ฆ๐—ง๐—˜๐—ฅ๐—–๐—Ÿ๐—”๐—ฆ๐—ฆ: https://www.excelforfreelancers.com/dashboard-masterclass-ytdesc โ–บ๐—•๐—˜๐—š๐—œ๐—ก๐—ก๐—˜๐—ฅ๐—ฆ ๐—ฉ๐—•๐—” ๐—–๐—ข๐—จ๐—ฅ๐—ฆ๐—˜: https://www.excelforfreelancers.com/ultimate-vba-ytdesc โ–บ๐—™๐—ฅ๐—˜๐—˜๐—Ÿ๐—”๐—ก๐—–๐—˜๐—ฅ'๐—ฆ ๐—”๐—–๐—”๐——๐—˜๐— ๐—ฌ: https://www.excelforfreelancers.com/freelancers-ytdesc โค๏ธ ๐—ฆ๐—”๐—ฉ๐—˜ ๐—•๐—œ๐—š ๐—ช๐—œ๐—ง๐—› ๐—•๐—จ๐—ก๐——๐—Ÿ๐—˜๐—ฆ ๐Ÿ‘‰ https://www.excelforfreelancers.com/bundle-products-yt-desc ๐„๐—๐‚๐„๐‹ ๐๐‘๐Ž๐ƒ๐”๐‚๐“๐’: โ–บ๐Ÿ’๐ŸŽ๐ŸŽ ๐“๐ž๐ฆ๐ฉ๐ฅ๐š๐ญ๐ž๐ฌ + ๐Ÿ๐Ÿ’/๐Ÿ• ๐’๐ฎ๐ฉ๐ฉ๐จ๐ซ๐ญ: https://www.excelforfreelancers.com/400-workbook-pack-ytdesc โ–บ๐€๐ˆ ๐“๐จ๐จ๐ฅ๐ฉ๐š๐œ๐ค: ๐๐ฎ๐ญ ๐„๐ฑ๐œ๐ž๐ฅ ๐Ž๐ง ๐“๐ฎ๐ซ๐›๐จ๐œ๐ก๐š๐ซ๐ ๐ž: https://www.excelforfreelancers.com/ai-toolpack-ytdesc โ–บ๐˜๐จ๐ฎ๐ซ ๐Ÿ๐Ÿ’/๐Ÿ• ๐€๐ˆ ๐‚๐จ๐ฉ๐ฒ๐ฐ๐ซ๐ข๐ญ๐ž๐ซ: https://www.excelforfreelancers.com/ai-content-generator-yt-desc โ–บ๐Š๐ง๐จ๐ฐ ๐˜๐จ๐ฎ๐ซ ๐€๐œ๐ญ๐ฎ๐š๐ฅ ๐„๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐ž๐ž ๐‚๐จ๐ฌ๐ญ๐ฌ: https://www.excelforfreelancers.com/labor-burden-ytdesc โ–บ๐Ÿฑ๐Ÿฌ๐Ÿฌ+ ๐——๐—ผ๐—ป๐—ฒ-๐—™๐—ผ๐—ฟ-๐—ฌ๐—ผ๐˜‚ ๐— ๐—ฎ๐—ฐ๐—ฟ๐—ผ๐˜€: https://www.excelforfreelancers.com/udvl-ytdesc โ–บ๐——๐—ฒ๐—ฒ๐—ฝ๐—ฒ๐—ฟ ๐——๐—ฎ๐˜๐—ฎ ๐—œ๐—ป๐˜€๐—ถ๐—ด๐—ต๐˜๐˜€ ๐—ช๐—ถ๐˜๐—ต ๐—”๐—œ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜: https://www.excelforfreelancers.com/ai-data-ytdesc โ–บ ๐Œ๐š๐ง๐š๐ ๐ž ๐‚๐ฅ๐ข๐ž๐ง๐ญ๐ฌ, ๐๐จ๐จ๐ค๐ข๐ง๐ ๐ฌ & ๐‚๐š๐ฌ๐ก ๐…๐ฅ๐จ๐ฐ ๐–๐ข๐ญ๐ก ๐’๐ฉ๐š & ๐’๐š๐ฅ๐จ๐ง ๐Œ๐š๐ง๐š๐ ๐ž๐ซ: https://www.excelforfreelancers.com/spa-salon-manager-yt-desc TIMESTAMPS: 0:00 - Introduction 0:24 - Overview 19:38 - Activate Worksheet 20:30 - Selection Change Event 22:44 - New Contact 25:22 - Save and Update Contact 38:17 - Cancel New Contact 38:53 - Delete Contact 40:04 - Load Contact 43:24 - Refresh Contact Table 47:27 - Sync to Database 51:27 - Sync from Database ๐‰๐Ž๐ˆ๐ ๐Ž๐”๐‘ ๐‚๐Ž๐Œ๐Œ๐”๐๐ˆ๐“๐˜ ๐Ÿ‘‰ https://www.excelforfreelancers.com/EFFGroup ๐…๐จ๐ฅ๐ฅ๐จ๐ฐ ๐Œ๐ž ๐Ž๐ง ๐Œ๐ฒ ๐’๐จ๐œ๐ข๐š๐ฅ ๐Œ๐ž๐๐ข๐š ๐€๐œ๐œ๐จ๐ฎ๐ง๐ญ๐ฌ: ๐Ÿ”—LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ ๐Ÿคฉ Facebook: https://www.facebook.com/ExcelForFreelancers ๐€๐›๐จ๐ฎ๐ญ ๐”๐ฌ: I help Excel enthusiasts turn their skills into passive incomeโ€”no need to trade time for money. If you enjoy these weekly videos, you can support Excel For Freelancers by grabbing one of our powerful tools to boost your Excel skills and chase your dreams. ๐†๐ž๐ญ ๐€๐ฅ๐ž๐ซ๐ญ๐ž๐ ๐ˆ๐Œ๐Œ๐„๐ƒ๐ˆ๐€๐“๐„๐‹๐˜ ๐–๐ข๐ญ๐ก ๐๐ž๐ฐ ๐…๐ซ๐ž๐ž ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  ๐•๐ข๐๐ž๐จ๐ฌ & ๐–๐จ๐ซ๐ค๐›๐จ๐จ๐ค ๐๐ฒ ๐’๐ฎ๐›๐ฌ๐œ๐ซ๐ข๐›๐ข๐ง๐  ๐‡๐ž๐ซ๐ž ๐Ÿ‘‰ https://www.youtube.com/c/ExcelForFreelancers/ New Training Videos Uploaded EVERY WEEK! ๐™๐™๐™–๐™ฃ๐™  ๐™ฎ๐™ค๐™ช ๐™ซ๐™š๐™ง๐™ฎ ๐™ข๐™ช๐™˜๐™ ๐™›๐™ค๐™ง ๐™ฎ๐™ค๐™ช๐™ง ๐™˜๐™ค๐™ฃ๐™ฉ๐™ž๐™ฃ๐™ช๐™š๐™™ ๐™จ๐™ช๐™ฅ๐™ฅ๐™ค๐™ง๐™ฉ, Randy Austin #exceltraining #workbooksharing #multiuserworkbook #macroenabledworkbook

Download

0 formats

No download links available.

Multi-User Excel Workbook Setup | Dropbox + VBA Magic | NatokHD