List out the details of files in a specified folder - automatically through excel without vba.

Hiii.
I was preparing a list of files (govt. forms) but it was difficult to manually copy the file name and paste into the excel sheet as there are more than 300 files in that folder.

After 8-10 copy paste I thought to do it automatically and the time saved is now used for writing this blog. LOL

Well, You can actually automatically list out the names of files in a specified folder into excel, assume that in a school there are 1000 students and their admit card is in one folder.. and for some reasons you need to list out it into an excel sheet.. So how you will do it...........


Here is a simple and superb way to do that........

These are the steps assuming your folder name is "Admit Card" and it is stored in D Drive...
1. Open a new excel file
2. Click on "Formulas" and then "Define Naem"
3. In the name field type AdmitCardList   (You can put any other name also)
4. In refers to Column type: - =FILES("D:\Admit Card\*.*")&T(NOW()) and press OK.
5. Now In your sheet 1 and cell A1 type or copy paste this formula
 =IF(ISERROR(INDEX(AdmitCardList,ROW()-1)),"",INDEX(AdmitCardList,ROW()-1))

and drag it downwards and you will see that your list is automatically updating.....





Hope the above can save your time too in case of huge data working and you will smile remembering this post...

Byee............... If you require the excel file, please inform........