I am trying to gather information from a series of worksheets onto a new
sheet. The information gathered would be based on the input in one
column. I have attached a sample estimate sheet, there are 12, 1 per
month. Currently the estimator can select 1 of three choices for the
status column, Awarded, Pending, Dead.

We are trying to track all jobs estimated by contractor name, and sort
them onto a new sheet broken out by the Awarded, Pending, Dead choices.


Preferably I would like to have it all work so that when an estimator
makes a choice on the estimate sheet, it will automatically go to the
correct place on the new sheet.

I hope I'm explaining this correctly. I need help figuring out what
the formula(s) would look like to have this happen.

Any help would be greatly appreciated.

~Trish


+-------------------------------------------------------------------+
|Filename: Estimate Worksheet.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4522 |
+-------------------------------------------------------------------+

--
trishl
------------------------------------------------------------------------
trishl's Profile: http://www.excelforum.com/member.php...o&userid=32705
View this thread: http://www.excelforum.com/showthread...hreadid=526225