Picking and copying data from another sheet

[marcidee]

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

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>

 

[onlyadrafter]

Hello,

Isn't it just a case of having a VLOOKUP?

i.e. = VLOOKUP(A2,(payslip macro, sheet 2 cols A & B),2,0)

you will need to change (payslip macro, sheet 2 cols A & B) to the actual workbook range.

 

[marcidee]

Thank you for your help - I will give this a try