I have an excel sheet with information about inventory products. The
list was origonally one worksheet. I broke up this work sheet into 6
different worksheets on the basis of the type of product it is. I now
have to update one column of the original data.

Is there a way to quickly and easily update a specific field WHERE one
field equals another field?

I would simply copy and paste the new field but now that i broke them
up into different worksheets, they are not in the same order and it
will no longer work.

Thanks
marc


--
goodfella
------------------------------------------------------------------------
goodfella's Profile: http://www.excelforum.com/member.php...o&userid=24405
View this thread: http://www.excelforum.com/showthread...hreadid=380083