Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I combine data from two sheets where field contents match?
I have two sheets in same workbook, first one is a list of parts with lots of
other data (product code, qty, etc) In the second sheet I have a list of parts with other data (#times quoted, qty, etc) I need to get the data from sheet two to appear on sheet one where the part numer is the same. So my first sheet will pull in the additional data on the parts from the second sheet. So like a link but where the part number matches. Sheet 1 a)Part# b)ProductCode c)Qty on sales orders d)Avg Sell Price e)Qty on work orders f)Avg Cost g) (from sheet 2) Qty on quotes h) (from sheet 2) Avg. Quote Price I have use paste special but I couldn't figure out how to only merge where a field content matched. Any tips to accomplish this (under time constraint, CEO wants by EODay). Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Combine and match two data | Excel Discussion (Misc queries) | |||
How do I combine data from several sheets into one main sheet? | Excel Worksheet Functions | |||
combine data from multiple sheets | Excel Discussion (Misc queries) | |||
How do I combine and match data from 2 sheets | Excel Discussion (Misc queries) | |||
How to append/combine (not add) data in several sheets into one? | Excel Discussion (Misc queries) |