sinfulloyolite
Board Regular
- Joined
- May 8, 2008
- Messages
- 79
I have a list of employees reimbursement amount payroll wise.
I need those to be populated into reimbursement form which is in excel template.
I would like to populate data from master list into reimbursement template (It will be one liner item to be populated as Allowance)
I can link first sheet with appropriate cells to make sure I have all needed values into the first form. (For your reference)
I want the further rows from master data to be copied similarly into multiple workbooks and have them renamed based on Employee name in the form and Payroll Date (DDMMM) cell A10.
I have attached images of my content
Any help would be greatly appreciated!
I need those to be populated into reimbursement form which is in excel template.
I would like to populate data from master list into reimbursement template (It will be one liner item to be populated as Allowance)
I can link first sheet with appropriate cells to make sure I have all needed values into the first form. (For your reference)
I want the further rows from master data to be copied similarly into multiple workbooks and have them renamed based on Employee name in the form and Payroll Date (DDMMM) cell A10.
I have attached images of my content
Any help would be greatly appreciated!