Grab data from all files with certain name in a folder

[Directlinq]

I have a folder called 2009
Is it possible to have a spreadsheet that when opened grabs data from every file with "*invoice" in the title in folder 2009 and all its sub directories and puts them into a list in the opened file?

The data needed is to be from sheet1, cells B16, C18, G18 from all the files
and i would like B16 put into A2, C18 into B2 and G18 into C2
Then the next sheets data B16 to A3, C18 B3 and G18 to C3 etc etc until all files with invoice in the title have been added.

B16 is a name
C18 is an address and
G18 is a postcode

This means there can be no duplicates so if opened twice there will only ever be 1 of the same address and postcode.

Many Thanks
if anyone can help it would be much appreciated

[shg]

Put this n a code module. Note that it requires a reference to Microsoft Scripting Runtime.

Please Login or Register  to view this content.

Then in another module, try this (untested):

Please Login or Register  to view this content.

[Directlinq]

I am getting a type mismatch error 13 at line

Please Login or Register  to view this content.

any ideas

Many Thanks

[Directlinq]

Ok sorted my mismatch error and now the macro runs but for some reason.

The cells that are being copied from the invoice sheet to the new sheet are working but when the macro reads the next invoice sheet it overwrites the prevous cells

Also is there a way i can stop duplicates appearing in the list??

Many Thanks

[JBeaucaire]

Try changing this line:

Please Login or Register  to view this content.

As for duplicates, even a SINGLE character difference would make an evaluation extremely difficult for Excel to do on its own.

Perhaps a separate macro you can use to sort the data by the address columns will make it simple for you to scan them?

[Directlinq]

Thank You Perfect