Thanks for the reply Sparks,


unfortunately I cannot get it to work the way I need it to.
A bit more of an explanation may help,
I am trying to archive of some records of customer repairs to another sheet.
When I enter a customers name that is already in the main sheet it will auto-fill with that name, the worksheet.change event fires after hitting return and gets the data from the row were the auto-fill found the match. This only works on the current sheet.
As the auto-fill only works on the current sheet/row I can't figure out how to also look at the archive sheet for the auto-fill data. Is this even possible to do?
regards
Trevor