Pasting lookup value (auto)

[Median]

I'm looking to copy the result of row D into row E

however

If any value in row D changes I want the code to automatically copy the new values into row E (this part has completely stumped me!)

Any advice would be massively appreciated.

Ty Mdn

[Bernie Deitrick]

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

[Median]

Fabulous bit of code Bernie

Just wondered how I could modify it in the case of copying two columns (i.e. copy column d into e, & copy h into i (simultaneously) - so far my attempts have been pretty woeful!

[Bernie Deitrick]

Try this:

Please Login or Register  to view this content.