Hello,

I have a workbook that I keep track of bids we have won and lost. All the
infomation is in a worksheet called "Bids". I list the dollar value of the
bid and have a column where I can put "Won" or "Lost". If we lose the bid I
put the company name in the column next to the "Lost" column. I have another
worksheet called "Lost Recap" that I keep track of the bids we lost. I list
the name of the company that won the bid, how many bids they have won for the
year, and the total dollar value for all the bids. My question is: is there
a way to automatically insert the company name, and dollar value in the "Lost
Recap" worksheet when I put the word "Lost" in column D of the "Bids"
worksheet? Also, it possibe to automatically insert each company that won a
bid to "Lost Recap" in sequential order? Any help is appreciated.

Thanks!
Mark