Hi,

That looks great, can you show mw what I'd need to do if the reference numbers are in column 'C' in the spreadsheet?

Thx,

John

Hi, wkb1 column: D00005628EM T035564/25/EM T043030/09+/EM wkb2 column: D-012\0833603-0002\D00005628EM F-012\001730373\TGP/AH/T035564/25/EM\NAOMI & NICOLE D-012\0833595-0002\D00005627EM F-001\008846693\HMB/IJI/T043030/09+/EM\CELEBRITY TEACHER F-026\001537056\T043038/36/CH\008909921\+\0 result wkb2 Co...

Hi, I have 2 excel workbooks that are created each month: workbook 1 has a column in it with reference numbers in each row (varying number of rows) workbook 2 has a column in it with reference numbers in each row but each reference number has other characters in the cell what I need to do is to go t...