Copy/Paste cell range from sheet 1 to sheet 2 in numbers match in reference columns.

I know Vlookup is has this function but I'm looking for something with a little more security and functionality when sheet 2 changes.

Looking for help with (VBA) in a search, copy, past range code.

Sheet 1 is the inventory sheet, Part number column (Q) Sell Price column (O) Quantity column (N)

Sheet 2 quote sheet, Part number column (A) Sell Price Column (H) Quantity Column (G) Quotes are sent to me and I change format.

If # column (Q) sheet 1 matches # column (A) sheet 2 () then copy the sell price and quantity from sheet 1 column (O)-(N) from the corresponding Row, then Paste that info into sheet 2 column (H)&(G) in the corresponding row.

No wander I can't get this one down typing it our was tricking..lol

The Quotes will change every month but the format will stay the same. I have used Vlookup but ran into trouble with it.
I'm not that good with VBA yet, I do have a little Exp. with it. I wrote VBA () that can find the matching #'s and change cell color of the matches only. Then move the info up. but only with sheet 1 and sheet 2 pasted together and sorted into one another creating a single sheet.

This is two confusing for the wife. She would like two sheets. And just move the info needed out of the inventory sheet to the quote sheet.
If I could get some Help with this It would be very appreciated. Thank You in Advance.

Sorry for my grammar.

BBB # 3205 on the quote sheet, this is telling me they want to purchase the 3205, in row 11, 3205MIX in row 850, this is telling me they will buy that body style of the unite in a mix,witch can be multiple part #'s. Also the data in (G) & (H) was supposed to be empty on sheet 2. I messed up and attached a completed quote, I will fix and attach a new one.

What I meant in the last half, sheet 1 is my inventory so that sheet data might change,Qty up & down more parts numbers added, price changes but the header format will always stay the same. Also in sheet 1 there can be more the one row with the same Lester # number in (Q) column. Lets say in row 5 was Part # 6659 Qty 10 @ $10.00 In row 50 part number 6659 Qty 30 @ $10.00 I would need Qty 40 moved over to sheet 2 and $10.00 put in the price cell in sheet 2. If a location for 6659 fills up in our inventory. Then we create a new Physical location for 6659 and new row will be created in the inventory workbook for 6659, now the inventory will have 2 row's with part # 6659.

The reason I was looking for VBA is so I could create a module, link a button to it, so when I paste a new quote into sheet 2 every month all I have to do Is click the button in sheet 1. but if you don't think it's necessary then I'm just probably over thinking it. Any way Thank you very much for helping me out.

I was wondering if we could add to the formula ( if there is a 0 or blank in the QTY cell (N) in sheet 1( (then display nothing in (G)&(H) in sheet 2. Thanks Again the formula works great the only thinks is I would have to manually remove all 0 and the price next to the zero's. If I could get it to display nothing if 0 or blank in the in the qty cell on the matching part # that would be great.