I thought at first it was that simple. Then I read again and decided, with you, that it's more complicated. But on a third reading I changed my mind again. He wants to fill in a name in sheet X (the customer list) and have that name appear in sheet Y, right? Why won't a VLOOKUP in sheet Y do the job?, combined with an IF(ERROR(...)) to keep from displaying #N/A. Obviously because I haven't understood his requirements yet. How would you describe them, Paul?