Skip to main content

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........
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing
2 comments
Read more

Sai Sampurna Padhi - A Sweet Bubbly Girl fighting for her life at Cuttack

Hello Everyone, Today I want to share with you all about a girl named "Sai Sampurna Padhi" Some details of this girl: - Name                   : - Sai Sampurna Padhi Age                       : - 2.5 Years Residence           : - Bidanasi, Cuttack, Odisha Father's Name    : - Linku Padhi Mother's Name   : - Chandrika Mohapatra Father's Occupation    : - Auto Driver at Badambadi Bus Stand, Cuttack This girl is admitted to SCB Medical College because she is suffering from a very dangerous disease called "Blood Cancer" and as its at Stage-I doctors has prescribed to go for Bone Marrow transplant as soon as possible so that this can be cured. But the operation cost around 20-25 Lacks which they can't arrange. For the time being, every week she has need of blood, plasma, test & medicine which is less as it is a government ho...
Post a Comment
Read more

Tally Trial Balance Consolidation Utility in excel

Hello Friends, Financial Year has ended recently and many of the accounts & finance professionals are ready for preparing the Balance Sheets. Many companies have operations at multiple locations and they prepare the accounts accordingly and at the end consolidate the data and prepare the Final Accounts. Normally the trial balances of each locations are consolidated and on that basis the Profit & Loss Accounts & Balance Sheets are prepared. Sometimes, the consolidation of Trial Balance is lengthy, tricky and difficult part for the accounts professionals although its a simple process of summarizing the transactions. So I am sharing an excel utility where upto 10 nos of Trial Balances (Tally Generated) can be consolidated within a minute. The Excel utility is self explanatory, but some basic points are mentioned here: - 1. You need to export Group Names of each locations from tally and paste in this file. 2. You need to export Trial Balance of each location from...
Post a Comment
Read more