On Sheet1 I have data running from A1-E1 with the number of lines o
data is undetermined so you need to look for the last row.

What I would like to do is check to see if there is a value in B1 or C
and if so- copy the line and move it to Sheet2. I want to do this fo
the remainder of the sheet moving copying lines with values in B or
to the next line on Sheet2.

Any help in code would be very much appreciated

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=54062