List Files in ANY Folder (Without VBA!) | Filter & Organize Your Files i...

Links to the actual files

simple way would be to add folder location with the file name and extension and use hyperlink with it. Wait for my next video and you can hyperlink those easily since it shows files in sub folders as well and has the folder location too. Folder location coupled with file name with extension when used with HYPERLINK formula does the trick.

There is one formula issue. You probably missed this because it is not really obvious. When you turn the list into a table, your first data row on Sheet1 is now row #2. Using "ROW()" in cell B2 references the current row and therefore returns number 2 to index into the file list. If you place the entire formula from B2 into E1 on Sheet1, you will see the missing filename. A simple fix is to replace "ROW()" with "ROW(A1)" in cell B2 AFTER the table is created. That way the correct index number will be used.

How To Use The Sequence Formula In Excel : 3 Practical Examples

Timestamps: 00:00 Introduction to the SEQUENCE formula 00:40 Understanding the SEQUENCE formula syntax with examples 03:03 Practical Example 1: Generating self updating serial numbers 05:52 Practical Example 2: Generating Dates 08:28 Practical Example 3: Generating a Dynamic Calendar 10:30 Conclusion and Recap