Hi All,

I have a new problem today that i need your help with.
I have a spreadsheet with a data validation list on it, and linked to this list in the cell next to it is a vlookup. When the user selects the customer name from the validation list the vlookup returns the customers code. This all works fine.

However we are always getting new customers so i need to update the list for the validation and the vlookup.

So i export the customers names and code via OLE (so always the same format) out of our accounts system and then paste special values only into my defined list.

But this seems to break the link between the items selected already as the vlookup returns an error. When i click into the validated cell, it has defaulted the selection up to the top again as if the existing name in the cell doesn't match the list. However the customers name is in the list. I can scroll down and pick it again and then it all works again.

Does anyone know why it is doing this and how i get round it. I have to update a ridiculous number of spreadsheets every week and i don't want to have to be reselecting the existing values every time.

Any help would be brilliant.

Thanks guys