T
trishl
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+