+ Reply to Thread
Results 1 to 2 of 2

VBA/Excel approach for a Last Saved/Edited column in a table with rows of data!

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    Vancouver, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    VBA/Excel approach for a Last Saved/Edited column in a table with rows of data!

    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:
    1. when the edit was made (in terms of time and date)
    2. who edited the data

    Is this feasible to do and what would be the best approach to this?

    Many thanks!

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: VBA/Excel approach for a Last Saved/Edited column in a table with rows of data!

    How about adding 2 more columns one for user and one for Date Amended. When you are saving the edited form write Now() to Date amended and Application.UserName to user.

    You obviously have the skills to read and populate the user form and then to save the edited data back to where it came from so these two additional fields shouldn't be too much bother, should they?

    Chris
    Last edited by Chris 53; 06-04-2013 at 07:19 AM. Reason: spelling!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1