The sheet is called master copy
range J:J criteria Water
range L:L criteria no job

thanks biff!


--
speakers_86
------------------------------------------------------------------------
speakers_86's Profile: http://www.excelforum.com/member.php...o&userid=36839
View this thread: http://www.excelforum.com/showthread...hreadid=565463