Find where three columns match in another spreadsheet

[VKD]

I am having problems with the find macro in Excel. I want to be able to match threes cells in on spreadsheet in another spreadsheet and copy the rest of the data.

Basically I have a master spreadsheet with work to be carried out, this is sent to employees who then send a cut down version (eg just their work) back. When they send their spreadsheet back (with a days worth of work, it may not have all their jobs in it) I want to be able to search the master spreadsheet and update it with their notes. Here's an example of the spreadsheet:
Name X-cord Y-cord Date Work Info Notes Date comp
Jan 265654 315152 12/02 check line line fixed 16/02
Dan 415452 112113 12/02 change battery line fixed 13/02
Ann 123654 324652 12/02 find problem prob fixed 13/02
Tom 123654 125536 12/02 complete 1 Done 12/02
Ann 632541 324652 12/02 check line line fixed 15/02

For example if Ann sent in her spreadsheet I would want to work through it line by line to find the row in the mastersheet where the x-cord, y-cord and work info match, and then fill in the notes and date comp (blue data) in the relevant row in the master sheet. Then do the same for the next line in her spreadsheet.

I can get the macro to find one matching cell and return the relevant row but I cannot get it to match three cells in the same row.

Can anyone help with this please?

Thanks in advance.

 

[namliam]

no way to 'really' match 3 columns in excel, need a database for that...

You can do it/fake it by concatinating the 3 columns into one and doing a search on the concatinated column, though that can be tricky sometimes.

 

[VKD]

Thanks anyway, I got the macro to put the concatinating exquation in and then match that column then delete the equation at the end. Cheers!