Good day everybody,
I have to setup a spreadsheet at work to track who uses our equipment and when it is returned.
This is what I want/expect the excel spreadsheet to do:
1. The employee will scan a barcode on a handheld. This will enter the equipment's name in the first row of the spreadsheet and will also add a date stamp to the 4th row (This is when it was signed out.) , and move to the second row.
2. The employee will then scan their badge and this will record their badge ID in the 2nd row and add their name on the 3rd row. This is accomplished via VLOOKUP.
3. Prevent them from deleting any data that has been entered.
4. At the end of their shift, they will find their name in the spreadsheet, scan the barcode on the equipment. This will in turn enter the equpment name in row E and add a date stampin row F. The cursor should then go to the last cell (i.e. in the attached spreadsheet, it'll be cell A5)
5. At the end of the day save the excel sheet with the date,to a network drive, and open a fresh copy of the same excel file.
This is what I have accomplished so far:
1. Enter equipment name + signed out time then move to next row
Please Login or Register to view this content.
2. VLOOKUP function to find employee name:
=VLOOKUP(B2,Sheet2!A1:B349,2,FALSE)
3. Prevent users from deleting data. My only problem is that if they highlight 2 cells and press on delete, it doesn't prevent them from deleting the data.
As I just started using VBA and after countless searches on the net, I am not sure how to implement steps 4 and 5.Please Login or Register to view this content.
I would be very grateful if someone can help me out.
Thanks a lot.
Bookmarks