Help Handling Input Data

[smiteme]

I have a scale that is inputing information into excel as it records weight. I need to set up either some sort of filter so that only weight between 45 and 60 lbs will be actually plotted into the spreadsheet, or I need to delete the row that does not meet this criteria as it is being inserted. Each new record the scale outputs to excel is stored in a seperate row in excel, and the data continuously feeds into excel as the weight is placed on and removed from the scale. The weight values start being stored in cell B16 and keep going until cell 406.

Thanks for your help!

[Kelshaer]

Use this in the sheet VBA code page

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If IsNumeric(Target.Value) = False Then Exit Sub
If Target.Row < 16 Or Target.Row > 406 Or Target.Column <> 2 Then Exit Sub
If Target.Value < 45 Or Target.Value > 60 Then Rows(Target.Row).Delete
End Sub

[smiteme]

This worked perfectly! Thank you so much for the help!

[Kelshaer]

Welcome, Please mark the thread as SOLVED