Auto Copy And Past

[Seifeddine87]

Hi just looking for how to make an auto copy and past
I have got all the data on my Stock sheet and when I go to sell sheets (from Jan to Dec) and put the item code in the sale sheet will copy Item Number Vehicles Category Parts Potition from stock sheet and past it in same row of sale sheet
Example
Stock sheet


…… ..A…………………B…………………..…C……………….……D…………..…..E…………………F…………….G
1…..Date……....Item Code……..Item Number……. Vehicles…….Category………Parts………Potition
2...02/12/16……..G52K51………033365258…………Clio…………….Body…..........Door………..FDS..
3...03/12/16……..G52M05………038555233…………Corsa………..Lights…........Headlight…..RDS..
4...05/12/16……..G52H52………033385214…………Clio…………….Body…..........Door………..FPS..
5 .

Sale Sheets (From Jan to Dec)
…… ..A…………………B…………………..…C……………….……D…………..…..E…………………F…………….G
1…..Date……....Item Code……..Item Number……. Vehicles…….Category………Parts………Potition
2...23/12/16……..G52M05………038555233…………Corsa………..Lights…........Headlight…..RDS..
3...28/12/16……..G52H52………033385214…………Clio…………….Body…..........Door………..FPS..
4...25/12/16……..G52K51………033365258…………Clio…………….Body…..........Door………..FDS..
5 .

 

[Scott T]

On the Sale sheet in cell C2 put the formula =VLOOKUP($B2,stock!$B$2:$G$4,COLUMNS($B2:C2),0) then copy across and down. Adjust cell references as need.

 

[Scott T]

Is duplicate Item codes possible? The Vlookup formula will only return the first matching code that it finds.

 

[Seifeddine87]

thank you very much for your help no there is no duplicate on the cods