I am novice to Excel. I am trying to create a simple spreadsheet for inventory scanning. In my department there will be total of 6 items scanned.
What I need is this:
A1 = user scans his/hers ID badge (this is a 6 digit barcode number from their ID tag)
B1 = user scans customer ID (this is a 9 - 12 digit barcode number)
C1 = use scans the items issued (this is 5 characters unique to item barcode tag, no 2 items barcodes are alike)
Upon item return, user (any user) would have to scan the item barcode (this would match the item on spreadsheet, mark it as returned), then user would scan their ID badge and this info would go with the item return for auditing purposes. Then the row matching the item issued/returned would become hidden, be moved to separate sheet, or something to keep spreadsheet very nice and clean. Like I said, we would need to be able to pull up the audit of which user issued the item, which user returned it.
Having a date of issue and date of return would be "nice to have" bot not must have.
Thanks all for reading this and for attempting to help. I truly appreciate it.
Bookmarks