Forum Discussion

Copper Contributor

Aug 31, 2021

Trying to create a workbook to track inventory. NEED a little help.

I am trying to create a spreadsheet to help track equipment assigned to our employees. Basically I created on sheet for the "warehouse" where we can scan in all the unique equipment barcodes. Then, I...

Equipment checkout.xlsm25 KB

Formulas and Functions

Yea_So

Bronze Contributor

Aug 31, 2021

CPI_LLC

Please share a sample file

CPI_LLC

Copper Contributor

Sep 01, 2021

I uploaded my project file. I just sort of pieced together some formulas I found, as well a a macro to generate the exact date/time whenever a new piece of equipment is scanned into the first column.