How do i reconcile the data with my data from many work books.

[Bangera]

Hi ,

I am looking for a help from anyone who can assist me on the below criteria.

1) I have a work book which has data of 10 country details.
2) I need to matche the details of my work book with the data of other country.
3) Heading varies from one book to another but thier will be two to threee uniqu details.
4)a)Invoice number )Invoice date c)Currency d)Amount remains same in all the 10 files.

My Macro should be such that it needs to copy the above specific data and copy to another sheet and do a matching with my file.

Is it possible ?

Regards,
Bangera

[Bangera]

Any One can assist ?

[marreco]

Hi

upload your file here.

[Bangera]

Attached the file

I have a masterfile on which the details of two files should appear in "Out Put"

[Bangera]

Any Expert Help here ?

[jaslake]

Hi Bangera

Update your Master File with expected Output.