Dear experts and friends,
Please be kind to help me to solve this issue, we have hundred's of employees who are getting company loans every month and loan details are maintained in a separate sheet for each employee, one example sheet is attached and every month I need to pick information to a summary sheet which is used as a supporting for salary deduction. Please help me to develop a formula where I can pick capital and inetest deduction for every employee number for relevant months from indivitual loan sheets to the summary sheet.
Regards,
Nishan
Please be kind to help me to solve this issue, we have hundred's of employees who are getting company loans every month and loan details are maintained in a separate sheet for each employee, one example sheet is attached and every month I need to pick information to a summary sheet which is used as a supporting for salary deduction. Please help me to develop a formula where I can pick capital and inetest deduction for every employee number for relevant months from indivitual loan sheets to the summary sheet.
Regards,
Nishan