+ Reply to Thread
Results 1 to 4 of 4

Help Handling Input Data

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Help Handling Input Data

    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!

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Help Handling Input Data

    Use this in the sheet VBA code page

    Please Login or Register  to view this content.
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Help Handling Input Data

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

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Help Handling Input Data

    Welcome, Please mark the thread as SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1