Hi,

I have a large set of data giving sales information by customer by
month over a period of time with each customers data held in a row.
Within each row are two calculations that define whether that customers
data needs to be put into a another report.

Im a relative macro and vba novice, and struggling to find a non manual
solution.

Really all I need is a way to assess a set of data and depending on the
contents of two cells in a row will then copy the entire row into a
separate sheet.

Thanks in advance for any advice!

RichE


--
RichE
------------------------------------------------------------------------
RichE's Profile: http://www.excelforum.com/member.php...o&userid=31539
View this thread: http://www.excelforum.com/showthread...hreadid=512312