S
Shashank
I have 2 sets of tables containing data of different period. Ex :The amount
withdrawn in an ATM of a bank in a particular period by cardholders of
different banks in a ATM sharing arrangement. These amount are reimbursed in
a settlement procedure in a subsequent period to the concerned bank. I have
got withdrawl as well as reimbursement files with card no , date, amount,
txn no. I want to generate a separate file matching each entry in one file
with the other one to ascetain at a particular time as to how many entries
are pending for reimbursement. Can any one suggest the procedure in excel
2007 to arrive at the result.
Shashank
withdrawn in an ATM of a bank in a particular period by cardholders of
different banks in a ATM sharing arrangement. These amount are reimbursed in
a settlement procedure in a subsequent period to the concerned bank. I have
got withdrawl as well as reimbursement files with card no , date, amount,
txn no. I want to generate a separate file matching each entry in one file
with the other one to ascetain at a particular time as to how many entries
are pending for reimbursement. Can any one suggest the procedure in excel
2007 to arrive at the result.
Shashank