Matrix

[Marco345P]

I am trying to get excel to look in a set range of cells for a specific text. After it finds that text I want it to go to another set of cells and pull that information out and place it in another worksheet. Can anyone Help?

[Conor]

Please clarify. What information are you pulling from the second range and how does it relate to the text from the first range? I assume you are using the first text as some kind of match field, but then what comes out of the second range? Do you want to place both pieces in the second worksheet and do you intend to concatenate them or what?

[Marco345P]

I have built a duty matrix, to track my guys and where they are scheduled to work each day in excel. Then I have to goto Word and type up the next days duty roster. What I am trying to do is have excel sort through the three letter post designator in the matrix and then pick the name from that row and place it in another excel document. The matrix tracks the duty schedule for a month at a time and the duty roster is only good for one day. Thanks in advance for any help. I am really struggling with this.

[Conor]

I still don't understand completely, but it sounds much less complicated with your second explanation. Can you zip your matrix file and post it? Unless it is completely obvious, you will need to specify the column where the 3-letter post designator is, the column with the name, how and where the date is specified. You mention "sort through". Does this involve sorting or do you mean "search through"?