Hello everyone,
I am building a spreadsheet table whereby I have many many rows of data - each row contains all the many details of a project; each detail is captured in a different column of the table. I have built it so that a summary sheet pops up, so that instead of reading across each row - you have it in a userform pop which shows all the vital information in one screenshot.
Within each summary userform, I have included the option to edit the details - so instead of editing the details in the table on the worksheet, you can edit the details on the userform pop up.
This spreadsheet will ultimately be used by many different people, all accessing the same worksheet - SO... I would like some way of tracking - and by that I mean capturing this information into one of the columns of the table, so each item on each row will have a different data in the form of:
- when the edit was made (in terms of time and date)
- who edited the data
Is this feasible to do and what would be the best approach to this?
Many thanks!
Bookmarks