2 sheets combined to 1

[KGEORGE13]

Hello,

I have 2 sheets.

Sheet 1: Sheet 2:

Part # Description Weight Part # Description Price
a xxxxx 2 b xxxxx 1.00
b xxxxx 14 c xxxxx 6.50
c xxxxx 5 e xxxxx 3.00
d xxxxx 1 f xxxxx 4.00
e xxxxx 2.5
f xxxxx 6
There are many more parts in sheet 1 (about 15,000 to 1,000 in sheet 2). I want to filter just the parts off of sheet 2 onto a sheet 3, while also bringing the weight's with them. Sheet 3 will look like this:

Sheet 3:

Part # Description Weight Price
b
c
e
f


I was thinking to use a COUNTIF function and reference sheet 2 to all of the parts in sheet 1 then filter out the "1"'s , but then I wasn't sure how to match up the weights with the correct correct prices. I haven't started working on it yet, being that I didn't want to waste any time doing this if there is an easier way. Any suggestions help!


Thank you!

 

[KGEORGE13]

A better look at the sheets:

Sheet 1:


Part # Description Weight
a xxxxx 2 b xxxxx 1.00
b xxxxx 14 c xxxxx 6.50
c xxxxx 5 e xxxxx 3.00
d xxxxx 1 f xxxxx 4.00
e xxxxx 2.5
f xxxxx 6


Sheet 2:

Part # Description Weight
b xxxxx 1.00
c xxxxx 6.50
e xxxxx 3.00
f xxxxx 4.00

 

[KGEORGE13]

messed it up again...it won't allow me to post picture

Sheet 1:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Part #
[/TD]
[TD]Description
[/TD]
[TD]Weight
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]xxxxx
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]xxxxx
[/TD]
[TD]14
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c
[/TD]
[TD]xxxxx
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d
[/TD]
[TD]xxxxx
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e
[/TD]
[TD]xxxxx
[/TD]
[TD]2.5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f
[/TD]
[TD]xxxxx
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Sheet 2:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Part #
[/TD]
[TD]Description
[/TD]
[TD]Price
[/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]xxxxx
[/TD]
[TD]1.00
[/TD]
[/TR]
[TR]
[TD]c
[/TD]
[TD]xxxxx
[/TD]
[TD]6.50
[/TD]
[/TR]
[TR]
[TD]e
[/TD]
[TD]xxxxx
[/TD]
[TD]3.00
[/TD]
[/TR]
[TR]
[TD]f
[/TD]
[TD]xxxxx
[/TD]
[TD]4.00
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Sheet 3:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Part #
[/TD]
[TD]Description
[/TD]
[TD]Weight
[/TD]
[TD]Price
[/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]xxxxx
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]c
[/TD]
[TD]xxxxx
[/TD]
[TD]5
[/TD]
[TD]6.50
[/TD]
[/TR]
[TR]
[TD]e
[/TD]
[TD]xxxxx
[/TD]
[TD]2.5
[/TD]
[TD]3.00
[/TD]
[/TR]
[TR]
[TD]f
[/TD]
[TD]xxxxx
[/TD]
[TD]6
[/TD]
[TD]4.00
[/TD]
[/TR]
</tbody>[/TABLE]