macro stock update

[gc1234]

Hi folks,

I hope i explain this well,

1. I have a sheet with stock that has been sold that has a box number ie: box6, so assume 3 lines of stock are listed


Sheet1
SKU BOX QTY
1234 BOX6 1
4321 BOX2 1
1256 BOX3 1


Sheet2
SKU BOX QTY
1234 BOX6 4
4321 BOX2 3
1256 BOX3 6


what i want to happen is if I place some code in the vb editor on a button control I would like to scan sheet1 and update sheet2 by the amount minus the listed items in sheet1... so if run results would be

Sheet2
SKU BOX QTY
1234 BOX6 3
4321 BOX2 2
1256 BOX3 5

Can anyone help.

thxs in advance







2. I have another sheet in the same file that has th

 

[gc1234]

ok..is it possible