T
trishl
I am creating a sheet that will bring over information from a series of
worksheets, and I want the update to happen automatically. What I have
is estimate worksheets, by month, so 12 of them. Data begins in B4 on
all worksheets. I have attached a word doc of the estimate worksheet.
The sheet I am creating needs to bring over Job Name, Estimate Amount
and Contractor name, based on the Status column. In the Status column
estimators have a choice of 3 items: Awarded, Pending, Dead(not
awarded). Ideally, I would like for information to flow from all
worksheets to the new worksheet when an estimator makes a choice in the
status column.
What would the formula for this look like? Any help would be most
appreciated.
~Trish
+-------------------------------------------------------------------+
|Filename: Estimate Worksheet.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4521 |
+-------------------------------------------------------------------+
worksheets, and I want the update to happen automatically. What I have
is estimate worksheets, by month, so 12 of them. Data begins in B4 on
all worksheets. I have attached a word doc of the estimate worksheet.
The sheet I am creating needs to bring over Job Name, Estimate Amount
and Contractor name, based on the Status column. In the Status column
estimators have a choice of 3 items: Awarded, Pending, Dead(not
awarded). Ideally, I would like for information to flow from all
worksheets to the new worksheet when an estimator makes a choice in the
status column.
What would the formula for this look like? Any help would be most
appreciated.
~Trish
+-------------------------------------------------------------------+
|Filename: Estimate Worksheet.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4521 |
+-------------------------------------------------------------------+