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