Premium Only Content

Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)
24 October 2019 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
With this Excel trick you can use a formula to show all the external links in your Excel workbook in one place. This way you can keep an eye on where the data is coming from and if any link is pointing to the wrong workbook.
With this Excel hack you can also write a formula to get the list of files from a specific directory and bring it to your Excel sheet. So if you're waiting for your colleague to add a file to a directory, you'll be able to see it in your Excel formula results once you refresh the list.
The fun part about this Excel trick is it combines 4.0 Excel Macros with Excel dynamic arrays. You can use the Excel Transpose function to get a vertical list of external links for file names.
⯆ Blog post is here: https://www.xelplus.com/excel-external-links-trick-dynamic-arrays
Bob's Excel Magic book on Amazon: https://amzn.to/2oVFRln
All about Excel's NEW Dynamic arrays - check out the complete playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
1:30:48
Redacted News
1 hour agoBREAKING! TRUMP AND PUTIN NEARING PEACE BUT EUROPEAN WARMONGERS TRYING TO STOP IT | REDACTED
19K31 -
52:40
Candace Show Podcast
1 hour agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
15.4K26 -
LIVE
Revenge of the Cis
2 hours agoEpisode 1449: Boo This
2,053 watching -
1:20:31
Awaken With JP
3 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
44K25 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K22 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
52 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
219 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
299 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1