Need help!

I have two seperate sheets. RawData (Needs to stay in Priority # sort)
and Overview

On the RawData there are approx. 30 columns for current projects.
Listing things like: manager, priority number, status ("AD" : row
contains the following results: "completed", "not started", "active").
Approx. 60 projects but need to plan on 250

I need to match up two of the 30 columns from the overview sheet:
Projects Status "not started" (Column "AD" and Manager (Column "D").

"Overview" file needs to show all projects not started, by manager
including a few extra cells found in the same row (priority numbers -
"A"), and (total hours - "T"). There is a second piece to this puzzle
but I think if I can see this example I can figure the other one out.

One option is to sort the data to another wookbook, delete rows and
copy over but I would like to do this automatically so that it will
always list all projects not started. I can also probably (not sure
yet), write a horrible macro to do all of this as well, so I would be
greatful for anyone's help on this as I am sure there is a much easer
way to do this.

It's late so if no one is understanding this please let me know and I
can get back to you with specifics.

Thanks!


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=533348