My Plan was to have the value be scanned in, the barcodes i have are a simple alphanumeric string.. first two letters are location, next letter is for monitors only, then a 3 number designation.

For example.. I have a workstation SB010 and it's monitor is SBM010 for the monitor designation.

I just want to have it where I have a running list of values say 010 to 500.. static (I'm a small company) and when I scan the barcode right now it auto-inputs the text from it, but in this instance it would be into a text box. then it would search for and display (if there was any..) data into the text boxes for the other 3-4 pieces of data i'm tracking. otherwise it would be blank, and I would manually input values and click a button to save it into my spreadsheet or another button to delete it from the spreadsheet.

also, the total monetary value that I have calculated in a formula i would like to keep displayed on the form as a label so that when entering a new machine it would update my total value of my assets.

Hopefully i'm not getting to complex, but that's the entirety of what I'm attempting to do. sof far i have a spreadsheet with all my current data that I would like to use as a data source if possible.