This is a hard one...

G

goodfella

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
 
P

PokerZan

Two comments/suggestions for you.

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

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

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

HTH,

PZa
 
R

Ron Rosenfeld

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
Click to expand...

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


--ron
 
G

goodfella

PokerZan said:
Two comments/suggestions for you.

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

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

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

HTH,

PZan
Click to expand...

Thanks ill give that a try
 
Top