Creating a summary of multiple files with the same formatting in a folder

[thebigdawg]

I am looking to create a revision log for a group of files in a folder, the number of files always changes it could be 2, it could be 20. In each file the name of the item is in cell C12 (could be A-3, A-7, B-3, anything with a letter then a number) and then in cell C9 the revision number is located. I am looking to make a macro which creates a list of 2 columns, that says the item name and revision number.

Thank you so much for your help!

[LJMetzger]

Attached is an Excel file (using Excel 2003 on a Vista 32 bit system) with Macros that may help you solve your problem. Two data files that I used for testing are also attached.

The Macros are also shown below to allow others to see the code without downloading.

Please Login or Register  to view this content.