Hi,

Hope someone can help. I have an example sheet with 3 tabs, Lookup, LD, PD. What I need is some code to search the lookup column A then find the field in the relevant sheet and then if it finds the data in the lookup replace it with the correct value in the lookup sheet. It may make more sense if you see my attached example.

So the first LD Sheet after the macro has run should read:

Fred 10.10.10.1 Test Environment
etc

The sheet called PD after the macro has run should read:

Fred 10.10.10.1 Cisco Systems Ltd

I need it to scan the LD and PD sheets to find the data and replace with the lookup values.

Thanks


Test.xlsx