One possible solution is to use the Worksheet_Change event. I have not
assembled any code to solve your problem directly, but I have used this
event to perform similar tasks. Hope this is a start
--
ngenear11
------------------------------------------------------------------------
ngenear11's Profile:
http://www.excelforum.com/member.php...o&userid=34844
View this thread:
http://www.excelforum.com/showthread...hreadid=545914