Using vb to paste records from 1 sheet, to related records in another
 

Hi all!

I'm really struggling with the coding logic behind this problem:

At the moment, I have coded a pivot table, which displays data in the
following format:

Sum of Quantity Location
Barcode 4 6 7 8 88 89

APL195X5 55 0 0 0 0 0
APL198X6 0 0 15 0 0 0
APL200X5 0 666 0 8 0 0
APL200X6 0 0 0 0 556 0
APL300X6 0 61 0 0 0 61
APL305X5 33 0 0 0 0 0

I need the counts area of these records to be moved to another sheet in
the workbook, which looks like this:

ON
PART NUMBER DESCRIPTION UOM LOCN HAND Total Stock Adjustment

APL149X5 FOR PLATES KGS BAYONE 4572 55 -4517
APL149X6 FOR PLATES KGS BAYONE 50442 15 -50427
APL170X5 FOR PLATES KGS BAYONE 0 674 674
APL190X6 TL4 PLATE KGS BAYONE 0 556 556

The counts need to go at the end of the associated record, using the
Barcode number as a kind of primary key

I.E:

Where barcode in sheet1 = barcode in sheet2, paste count cells

Any help at all would be appreciated, even if it's just a link to any
website where I can learn how to do this!!

Thanks very much,

Chris