Automatically pull data into another worksheet within the same fil
 

How can I automatically pull data that meets a certain criteria into another
worksheet within the same file?

For example:
Sheet 1 contains 16 columns of data relating to a customer. If an €œx€� is
placed in one of the final 5 columns (prospect, new sale, renewal, not
interested, or other) then that entire row of data would move to the
respective worksheet below.

Sheet 2 = Prospects
Sheet 3 = New Sale
Sheet 4 = Renewal
Sheet 5 = Not Interested
Sheet 6 = Other

Is this possible?

Thanks!

Start here
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJess" wrote in message ...
How can I automatically pull data that meets a certain criteria into another
worksheet within the same file?

For example:
Sheet 1 contains 16 columns of data relating to a customer. If an "x" is
placed in one of the final 5 columns (prospect, new sale, renewal, not
interested, or other) then that entire row of data would move to the
respective worksheet below.

Sheet 2 = Prospects
Sheet 3 = New Sale
Sheet 4 = Renewal
Sheet 5 = Not Interested
Sheet 6 = Other

Is this possible?

Thanks!