On Fri, 17 Jun 2005 09:09:00 -0500, goodfella
wrote:


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

Depending on your structure, you might be able to use a VLOOKUP formula.


--ron