Is it possible to pull items selectively

[jrob183]

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
I have two worksheets that will be constantly updated with contact lists then a third worksheet that has a contact list that needs to be a subset of the first two worksheets. Each contact has multiple columns of data such as company name, position, phone number, etc. and each contact has its own row. I created a column where I can put a "1" and I want to make it so that excel searches that column in each of the first two worksheets for the "1" if it sees a "1" in that column it will pull everything in that row or everything in that row from lets say column C through K which ever is easier and put it into the third worksheet. In the end I want to have a contact list in the 3rd worksheet that contains all the contact information from contacts that I put a 1 next to in the first two worksheets.

Is this possible or do I need to work this manually?

Jessica

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=564591

Please do not post the same question multiple times. If you have not gotten a response to your first question, you can "bump" your original post back up to the top simply by replying to it. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

If you have not gotten any responses, it may be a sign that your question is not quite clear. Often times, posting examples can make things a lot clearer. You cannot upload files to this site, but you can post screen shots using the tools mentioned here: http://www.mrexcel.com/forum/showthread.php?t=508133

So I would recommend replying back to your original post with more detailed explanations/examples/screen shots.