Checking then copying data to open workbooks

[lauzer]

Hi all,
I've tried re-writing this post to make it simpler but am not sure I can do anymore. This site has been a life-saver to me and some of you guys out there really are amazingly nice people so thankyou in advance if you can spare a couple of minutes to read this post.

I had a very nice chap help me out on a dummy workbook(attached) but he appears to have disappeared in my time of desperate need. Thus I am searching for some kind soul to simply add a couple of lines of code to finally get it working.

I'll let you know my issue- I have 5 workbooks open at once(named BOOK1, BOOK2, BOOK3, BOOK4 BOOK5, lets say) each have several named tabs with 400 rows of data in each tab. Each line within, is a project that may or may not have been completed and scored yet but already has a VIN(individual number) allocated to it. When they are scored, the VINs are provided in a 'new' update sheet and I am to input the scores on each of the corresponding rows within the 5 master workbooks.

So, as there are 20000 projects, we're trying to have a button(CommandButton1) that will take each VIN from the update sheet, find the corresponding VIN on the correct tab on one of the 5 open workbooks and replace the two empty cell to it's right with the score to the right of the VIN in question from the update sheet. As some of the projects are already checked by other people(610 & 620), we then tried another button(CommandButton5) to run first that checks the 5 open workbooks first and if it already has a score then delete that row on the update sheet so as to not re-check it.

CommandButton5 does exactly what is needed. The thing that is missing is with CommandButton1- rather then JUST copying the score across, I also need it to copy the 2nd score in the next column as well, as each VIN has 2 seperate scores to them.

I do hope that's clear- this has been driving me mad for weeks now and, what with being so close to success, I would be eternally grateful to anyone that has a spare minute to quickly look at the code on the update sheet, and put it right. You have no idea how much of an impact this small bit of code will have on my life and future prospects of being kept on at this lovely workplace, when my temporary contract expires.

Respectfully yours,

Lauzer