I need some help please. I have researched and researched, but I cannot find what I am looking for. I have read almost every thread about this.

I need an excel document (or Access) that can help keep track of Transferred Items. I have 5 “Coordinators” that will be using this form to track Transfers from 130 establishments.

* I want the document to be locked anytime information is entered (they input data and then when saving it locks the row and cannot be changed).
* Which means the last row without data should have a “new” or “add” button that opens the row for them to use.
* I want to automatically assign a transfer number based off of the last number used.

If it is in Access, I would like them to be able to pick their name when they first open the file. So that we can see which Coordinator is inputting the information.

PLEASE HELP ME WITH WHATEVER MACRO OR OTHER INFORMATION I NEED TO MAKE THIS WORK