How to update Page field using result in another cell from drop down?

Originally Posted by spmorin

Thanks for the reply. This is the site I have been using for most of my samples and such. I did copy as the examples states. I am now able to get the code to work if I was the target cell with the validation, how ever if I use the target cell with a vlookup, it will not work.

I wish to use the vlookup as I am using two different sheets for the data, however I can combine, just takes abit more work.

any other input appreciated.

Thanks

Maybe worksheet_calculate would work then........