VBA and autopoulate

[prescotmunn]

Hello,
have a farily large database of around 2000 people, sheet1 has all of their names and relevant details. Sheet 2 has data pulled on from a site. I would like the data from sheet 2 to auto populate the cells in Sheet 1. Also if the person does not exist in sheet1 to highlight the data it couldnt do. I am so stuck on this.

https://filetea.me/t1sfGPWECvdQqmgVDGtXL4oRQ

 

[MickG]

Your Website cannot be found !!!
Try:-
https://www.box.com/home

 

[prescotmunn]

Your Website cannot be found !!!
Try:-
https://www.box.com/home

Thanks please try https://app.box.com/s/b5h9ojxvnei7or2ircbi5fwznzd8eyp2