This is a hard one...
 

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

Do I need to explain this better?


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

Two comments/suggestions for you.

1. Why break up the products into 6 different sheets? If you ever want
to look at just specific products (as long as you have a column that
indicates product type) you could just use a Pivot Table to sort by
type, then drill into the product specific information.

2. VLOOKUP is the answer for your problem here and would be a snap if
all your records were on on sheet, but still doable for your situation.
VLOOKUP looks vertically down a spreadsheet and returns a specific
field from another sheet when a common cell is found, in this case I
would look it up by part number.

If you haven't used VLOOKUP before it is probably one of the most
useful tools in Excel for merging and compiling data from differnt data
sources. Do a search for VLOOKUP on the forum for step by step
instructions.

HTH,

PZan


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

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

PokerZan Wrote:
Two comments/suggestions for you.

1. Why break up the products into 6 different sheets? If you ever want
to look at just specific products (as long as you have a column that
indicates product type) you could just use a Pivot Table to sort by
type, then drill into the product specific information.

2. VLOOKUP is the answer for your problem here and would be a snap if
all your records were on on sheet, but still doable for your situation.
VLOOKUP looks vertically down a spreadsheet and returns a specific
field from another sheet when a common cell is found, in this case I
would look it up by part number.

If you haven't used VLOOKUP before it is probably one of the most
useful tools in Excel for merging and compiling data from differnt data
sources. Do a search for VLOOKUP on the forum for step by step
instructions.

HTH,

PZan

Thanks ill give that a try.


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