not too elegant, but find/replace might do the trick

or give each sales person a number rather than their initials for their
filename so the numbers can be re-used

otherwise you need to read up on address() and indirect() functions
it will be possible to do it using those but very convoluted


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556041