My Online Training Hub
Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
I wrote a macro a few weeks ago which created a list of files with hyperlinks to those files, but didn't traverse subfolders looking for those files. So it was limited to the folder you selected. This improved macro will : Ask you what your root (starting) folder is Ask you for the file type …
So you have a load of PDF's, or scanned documents, or some nice pictures of your stamp collection*, and you want to get this list into Excel. But you also want to be able to click on that file name/link and have the document/image open up in Excel. Easy. * I don't have a stamp …
I like to use Excel hyperlink buttons in my Excel workbooks to help with navigation. I link them to a Shape that looks like a button to make it intuitive for the user, and also because I think it looks nicer than a text hyperlink. If I have a lot of worksheets in the file …
These Excel Factor tips were sent in by Zoran Stanojevic of Belgrade, Serbia. Words by Mynda Treacy Zoran has prepared 3 distinct ways we can apply hyperlinks that dynamically update depending on the selection we make. The selection can be controlled with either a data validation list or a spin button form control. Download the …
If you work in large Excel files, Word documents or even e-mail, you may find it takes a long time to navigate and find the location you’re after. Hyperlinks are like a time machine in that they can take you there in an instant (but unfortunately they can’t take you back in time), and the …
