Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 15th 04, 07:53 PM
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!


  #2   Report Post  
Old November 15th 04, 08:00 PM
Ron de Bruin
 
Posts: n/a
Default

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!





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro does not run when data refreshed Larry Lehman Excel Discussion (Misc queries) 0 January 16th 05 07:31 PM
how do I make a copy of a worksheet and retain formulas but not data FireBrick Setting up and Configuration of Excel 2 December 29th 04 07:33 PM
How do I pull in multiple data sets at once? Doug Excel Discussion (Misc queries) 0 December 6th 04 12:37 AM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017