I need help with my inventory tracking. I need to scan computers that have barcode tags on them. I have the scanner setup to scan and hit enter, so I can just fire away one after another. I have an excel spreadsheet that I export from a website that houses the data I need. This spreadsheet has data such as asset number, serial number, location and model. This data changes daily/weekly. I copy and paste this spreadsheet into my template I have and it helps with comparisons and counting. I reference the page and columns on this sheet other places to count the data currently.
I want to be able to just scan the asset tag (sometimes alphanumeric) and have a count populate in multiple areas. For example. right now I scan the items in specific columns and then reference those columns in a COUNTA formula to count everything I scan in a particular column. I want to scan an item, lets say the asset tag is 123456, and for excel to know the model is TXZY computer and the location is Closet. Then I want it to automatically count on another page and column for Model and Location categories. So when I scan 123456, the count in Model TXYZ column and Closet column would be a 1. If I scan another asset with that information, then the count would go to 2 etc. If I scan, say 12347, and it is TXYZ model, but Lab location, then I want it to populate in the same way.
My ultimate goal is this. Export spreadsheet of data from website. Paste/import into my excel template. Scan asset tags from any location and any particular models at my business and have them appropriately counted in different categories automatically. Please let me know your thoughts.
Bookmarks