View Single Post
  #1   Report Post  
TJess
 
Posts: n/a
Default 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!