VBA Match To Column & Cell and Copy

Hi I wonder whether someone could possibly help me please.

I'm trying to put together a short script which performs the following:

• Compare column D on the "All Resources" sheet with column B on the "WA - Platform" sheet.

• Where the names match, then compare column G on the "All Resources" sheet with cell "B3" on the "WA - Platform" sheet.

• Then once these match, copy the value from column H on the "All Resources" sheet and paste on the relevant row in column D on the "WA - Platform" sheet.

From some guidance I've received before I've put together the following, but I can't seem to create the second and third match:

Please Login or Register  to view this content.

I appreciate that my description may not be enough, so I've attached a file to illustrate the file.

I just wondered whether someone may be able to look at this please and offer some guidance on how I may go about achieving this.

Many thanks and kind regards

Chris

Hi Chris,
I have done it Mick's way, but not sure if it is the right output.