Populating Data into different workbook based on on Template from Master Data

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!
 

Attachments

  • Master Data.PNG
    Master Data.PNG
    31.6 KB · Views: 4
  • Reimb Form.PNG
    Reimb Form.PNG
    32.1 KB · Views: 4

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top