Use the add new data macro button to add sample values to the quality control chart:
65,67,64,66, and 68. Verify that the new data is added to the control chart and to the QC Data worksheet.
Also verify that the sample values 67 and 68 are reported by the macro as being out of control.
So I have already assigned the New Data Button, but am so confussed on how to add what is above.
Please help
ActiveCell.FormulaR1C1 = "new_data variable"
Range("C4:E4").Select
Selection.Copy
Range("C3:E3").Select
ActiveSheet.Paste
Range("E4").Select
Sheets("QC Chart").Select
65,67,64,66, and 68. Verify that the new data is added to the control chart and to the QC Data worksheet.
Also verify that the sample values 67 and 68 are reported by the macro as being out of control.
So I have already assigned the New Data Button, but am so confussed on how to add what is above.
Please help
ActiveCell.FormulaR1C1 = "new_data variable"
Range("C4:E4").Select
Selection.Copy
Range("C3:E3").Select
ActiveSheet.Paste
Range("E4").Select
Sheets("QC Chart").Select