Excellent video, but raises some questions about your formula. FILES() is not an Excel function, so where does it come from? Also dies that mean NameManager can run code from other languages? .
Excellent, thank you. 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.
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.
Would be nice when you explained why first are only 300 entries could used, second I wont drag down the cells to I dont know 600. List all files mean for me: klick and list it.
🔗Links🔗 Practice File 👉 tinyurl.com/55znynzh Effortless Excel Navigation: Create an Interactive Index for Multiple Sheets | 3 Methods 👉 ruclips.net/video/16LyoHkKLQo/видео.html How To Use The Sequence Formula In Excel : 3 Practical Examples 👉 ruclips.net/video/Aac6sz2b6Dw/видео.html
Excellent video, but raises some questions about your formula. FILES() is not an Excel function, so where does it come from? Also dies that mean NameManager can run code from other languages? .
Excellent, thank you.
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.
Very useful. Thank you!
Glad to hear that!
Awesome bro keep rocking
Thank you so much 😀
Fantastic! I think it would even become better if you make them become 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.
Very interesting. What about managing also subfolder ?
I thought so too. And that's why its coming in the next video this friday!!
Can we do similar and get list og folders?
We can. Wait for the next video, it covers file list in ALL the subfolders & folder list too!
Would be nice when you explained why first are only 300 entries could used, second I wont drag down the cells to I dont know 600. List all files mean for me: klick and list it.
🔗Links🔗
Practice File 👉 tinyurl.com/55znynzh
Effortless Excel Navigation: Create an Interactive Index for Multiple Sheets | 3 Methods 👉 ruclips.net/video/16LyoHkKLQo/видео.html
How To Use The Sequence Formula In Excel : 3 Practical Examples 👉 ruclips.net/video/Aac6sz2b6Dw/видео.html