Dear All

i have one control sheet which contains all the details of clients
according to their account no. and the amount.
There is one more file which i receive on daily basis from my Central
office which again contains details of some clients,now my job is to
match up this data and send again with match and unmatch details to
central office.
Currently i am using vlookup function manually to doing this activity
but at the colume increases it become very time consuming and there
are chaces of error too when there are two different beneficary for
same client with the same amount.

Is there any macro available for it?

Regards