sorting on lots of worksheets

Can you attach maybe a couple of examples from your list of hundreds?

Are all these workbooks in the same folder?

All the files are store in a parent folder split into subs folders:

Parent Folder

is then split into

Builders
Business
Church
Private
Schools

split further

Builder1
Builder2
Builder3

Business1
Business2

(Ect.)

And then

2004
2005
2006
2007
2008
2009
2010
2011

and then

List of excel files

1. invoice 1.xls
2. invoice 2.xls
(And so on)


I have included a template of the excel files format

i need to search all the files above and extract the Date,Invoice Number,Date work completed (All the excel files are the same format)

Then i need to save all the data into a main worksheet so i can sort them in order of date and give each one a unique number 001,002,003......9999 ect.

Have a go with the folder contents macro on my download page to generate a complete list of your files. If this works, it should be straightforward to create some extra code to extract the data from each one.

Hi nightsurfer2004


In your Invoice Template

• Date is in Cell G8
• Invoice Number is in Cell H10
• Date Work Completed is in Cell H12

Will this ALWAYS be true for ALL Invoices?

Assuming the parentfolder is "E:\parent"

Please Login or Register  to view this content.

Hi nightsurfer2004



This code in the attached assumes this

In your Invoice Template

• Date is in Cell G8
• Invoice Number is in Cell H10
• Date Work Completed is in Cell H12

and that this will ALWAYS be true for ALL Invoices. You'll need to change the line of code as indicated.

Please Login or Register  to view this content.

The code has been tested extensively...let me know of issues.