Thank you so much. You have helped me immensely! I was able to get it to
work on my spreadsheet using steve's way. I tried it first using biff
method but I kept getting errors when I tried the offset command in the
data validation. I don't know what I was screwing up but anyways its
working now. Again thanks to you both!
Lisa


--
vencopbrass
------------------------------------------------------------------------
vencopbrass's Profile: http://www.excelforum.com/member.php...o&userid=31868
View this thread: http://www.excelforum.com/showthread...hreadid=515971