Hi Pecoflyer,

thanks for the quick reply, I have done that but the names may be changing and there are 650 of them and I am actually setting this up for someone else who would not have the best of excel knowledge(even less than me if thats possible ) so I would like to have them linked from one sheet to the other. The only way I can see it being done at the moment is manually and as I said I would prefer not to have to do that manually.

Thanks