Electronic Trailer board, that pinpoints user activity.

[BasicCraig]

Hi All,
I've been playing around with a new thing to make Our yard and trailer board activity easier.
I've managed to get so many of the sheets to sync but when it comes to some coding, I have the ideas but going round in Circles.

It would be a shared sheet across multiple users.
The only place I want them to update the data is on the Trailer Yard Check, When however they update a bay I want it to update into the yard entry Tab, which then would Date and timestamp when they updated it. I'd then also want the username that updated the Bay to update in row J on the Yard entry tab.
Once they have completed updating the sheet, I have a macro that runs that copies the data and places it onto a tab called "database" I wanted that for traceability to understand if something went wrong or missing etc. Ideally I'd like this to only update with new entries. and not duplicating the fact trailer 1234 is still sat in location F1 as an example days later.


I don't know if I'm overcomplicating what I want to do.
But simply I want to update and track and trace trailer movements in the yard and identify who has updated the bay.
If there is something else that can be done to make the sheet easier on that basis I'm open to ideas.

New to this... So hopefully I've added the file to this thread.

[CheeseSandwich]

Something to think about on a shared workbook containing VBA is that a row will seem to be blank to user1 so the VBA will fill it, if user1 does not save the file yet then user2's VBA will see the same row as empty so will also fill it. When user1 or user2 try to save the workbook there would be a conflict and Excel will ask which one to save rather than saving both.

I know this does not help with your issue but thought it was worth noting.