Vlookup and copy data back into original data

Hi Guys,

I have some script that copies data from an original sheet "Details" into 5 separate sheets depending on some logic ( e.g. A value > 7 and P = "").

but when I update the data on these separate tab I need to be able to copy some details back into the original data.

E.g.

"Details" Table :

ID	Read
001	1234
002	4567

Copied to the "Readings" Table where I change the read data:

ID	Read
001	1111
002	2222

And then I need to run a macro that looks up the ID from the "readings" table in the "details" table
And updates the Read from the "readings" table back into the "details" table

"Details" Table now needs to look like this :

ID	Read
001	1111
002	2222

I have the copy done so I just need some assistance with the copy back if possible please ?

Thanks
Sarah

Which columns are the ID and Read for each sheet?

@ JOHN H. DAVIS - the "ID" is column B and the "read" is in G

Maybe:

Please Login or Register  to view this content.

@ AlphaFrog - Please see attached

Thanks John ... I'm get an object required compile error on this line ?

Please Login or Register  to view this content.

My mistake:

Please Login or Register  to view this content.

That perfect - Thank you very very much for your help ....

You're welcome. Glad to help out and thanks for the feedback and the reps. Please mark this thread as SOLVED.