Help w/ VB to match & calculate
hello,
I have the following data:
Wrkctr Mach Setup Run
MCB607 5 30
XJ2607 5 10
QPU607 5 2
XM4607 15 5
XM4607 2964 815 15
XM4607 10 5
XM4607 15 5
XM4607 10 5
XM4607 15 5
XM4607 2964 750 15
XM4607 2964 100 15
XM4607 5 0
XM4607 10 5
XM8607 9435 5 60
XJ2607 15 120
XJ2607 15 10
QPU607 5 2
XM6607 4955 90 600
XM8607 9435 15 30
XM9607 0 240
XM9607 5 74
XN8607 9436 23 10
XN2607 PA111 30 1
QP5607 4 24
XJ2607 7 1200
QPU607 5 45
QPU607 5 10
QPU607 10 60
QPX607 5 45
I need to create a macro to give me this results:
Wrkctr Setup Run Cycle time
MCB607 5 30 35
QP5607 4 24 28
QPU607 30 119 149
QPX607 5 45 50
XJ2607 42 1340.2 1382.2
XM4607 1745 75 1820
XM6607 90 600 690
XM8607 20 90 110
XM9607 5 314 319
XN2607 30 1 31
XN8607 23 10 33
Calculate the sum of setup and run time for each wrkctr. The cycle time is
sum of setup & run time. number of rows of data vary. Thanks for any help.
|