Lookup, copy, insert data

[[email protected]]

Hello,

I've attached a sample spreadsheet to help explain. There are 3 tabs Parts, Pricing and After. The After Tab is basically what I'm looking to do.

1. Search all part#'s in the Parts tab to the Pricing tab.
2. If the part# exists in that tab, copy and insert the multiple price breaks into the Parts tab.
See the After tab for my example.

Any help would be greatly appreciated!

[StephenR]

Try this:

Please Login or Register  to view this content.

[[email protected]]

Works great! But.....in the sample spreadsheet had less columns and won't work on my original. Can you explain what does what above to help understand what I need to change to work on my original? Thank you again, it work great on the sample I provided.

[StephenR]

Why not post a sample of your actual data?

[[email protected]]

I didn't really have a finished plan yet but I think this pretty much sums it up. I was hoping to do most of it myself but appears to be more complex than I thought. I've attached a new "Sample' tab with the results I'm looking for.

1. I need it to search the part# located on the "Parts" tab in the "Pricing' tab
2. Once it finds price breaks, copy those breaks into the "Parts" tab
<<<<< which you got to work -- Thank you StephenR! >>>>
New changes:
3. I need those copied price breaks to have a formula linked to material and labor increase as shown.
4. Lastly, do the reverse.... copy all the new pricing back into the "Pricing" tab so it can be imported into our ERP system.

If it makes it easier to have the price breakouts in their own 2 columns that's fine also.

Sounds pretty easy.......... Ya right!

I appreciate all your help!