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

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