List of filenames from folder into Excel

Copy Folder Path into excel. Add "\*" onto end of folder path. Make a named range using the formula =FILES() and then use the named range to get a list of file names.
---------------------------------------------------------------------------------
#exceltips #exceltutorials

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 2012
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
Copy list of filenames from folder into Excel (Windows)    • Copy list of filenames from folder in...  
List of filenames from folder and subfolders into Excel    • List of filenames from folder and sub...  
List of filenames from folder into Excel (Windows)    • List of filenames from folder into Ex...