C
chrisnichols87
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
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