Please can someone help with a formula or VBA script.
I have one workbook (payslip sort) that contains several sheets (one sheet per person that contains a breakdown of their pay) - I have another workbook (payslip macro) that contains a list of names in column A and next to their names in Column B their email address.
Is it possible to have a code that looks up the name on each sheet in (payslip sort) which can be find in A2 (see below example) - and search for that name in the other worksheet (payslip macro) (the list at present located in sheet2 - however this can be moved if that is a problem or even added to the main worksheet) - and copy the email address to i1 in payslip sort.
Payslip sort
<colgroup><col><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>
Payslip macro (sheet2)
<colgroup><col span="3"></colgroup><tbody>
</tbody>
I have one workbook (payslip sort) that contains several sheets (one sheet per person that contains a breakdown of their pay) - I have another workbook (payslip macro) that contains a list of names in column A and next to their names in Column B their email address.
Is it possible to have a code that looks up the name on each sheet in (payslip sort) which can be find in A2 (see below example) - and search for that name in the other worksheet (payslip macro) (the list at present located in sheet2 - however this can be moved if that is a problem or even added to the main worksheet) - and copy the email address to i1 in payslip sort.
Payslip sort
Name | P/E Date | Shift | Company | Location | Units | Pay Rate | Total Pay | zak@bbc.com | ||
Zak | Mon 29 Jul 2019 | NA - Day | Constance | xxxxxxxxxxxxxxxxxxxxxxxxxx | .50 | 9.00 | 4.50 | |||
Zak | Mon 29 Jul 2019 | NA - Day | Dermott | xxxxxxxxxxxxxxxxxxxxxxxxxx | 45.00 | 9.00 | 405.00 | |||
Zak | Mon 29 Jul 2019 | NA - Day | Kelly | xxxxxxxxxxxxxxxxxxxxxxxxxx | 1.00 | 9.00 | 9.00 |
<colgroup><col><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>
Payslip macro (sheet2)
Zak | zak@bbc.com |
nigel | nigel@itv.com |
barry | barry@sky.com |
<colgroup><col span="3"></colgroup><tbody>
</tbody>