I have three worksheets,

1. Stock Produced
2. Stock in Port
3. Stock Shipped.

All the stocks which we hold are in teh Sheet Stock Produced.

can i have a formula in excel, whereby as soon as i enter the PartID in
"Stock in Port" sheet, a column in teh Stock Sheet says, Stock in Port.
And Once i enter the PartID in Shipped Sheet, the column reads "stock
Shipped" and the PartID disappears from "Stock in Port" sheet.


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=560983