Sorry, after reading the responses I realized that the sheet I am trying
to combine information on is an automatic fill data sheet which adds
zeros for blank cells from the master sheet....and I had supressed the
zeros showing on the form...I had completely forgot the zero is
actually in the cell, just not showing. with that added information,
is there a way i can combine the cell data and not have the zero show?


--
Karmen
------------------------------------------------------------------------
Karmen's Profile: http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=522413