+ Reply to Thread
Results 1 to 2 of 2

Keep record of all changes within a table.

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    Ireland
    MS-Off Ver
    Office 365
    Posts
    1

    Keep record of all changes within a table.

    Hi,

    I hope I am in the forum for this query. I have a work book that I currently use as a risk register within work. The way I have it set up at the moment is. each division has its own individual sheet and hten using power query I have appended each of the sheets to create a master data sheet. This sheet keeps everything up to date and current with the push of the refresh button.

    However this is where things get a little tricky and I am unsure if this is even possible. I have been asked to record all changes made to the register. I am hopoing that I can create an additional sheet that wil auto populate any changes made to the master data sheet. If the description changes, mitigations or score.The last version of that entire row will copy to the changes sheet and the master data sheet will be up to date and current. I have attached a sample workbook owith the type of data I am recording.

    Hoping to find a solution to this. Thanks in advance for any help

    Office Suite: Office 365
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Keep record of all changes within a table.

    Hi
    Depending on which edition Office 365 you are using it may be possible to:-

    Save the workbook with a different version ie workbook v1, workbook v2 etc
    Then use an excel add-in Inquire. I believe you will need Professional Plus version of Excel.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Find/Replace Record in One Table Based on Records in Another Table
    By DavidFC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2018, 04:41 AM
  2. Replies: 0
    Last Post: 01-19-2015, 11:00 AM
  3. Pivot Table, use VBA to get use back to record in source data table
    By gr8tday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2014, 01:30 AM
  4. Replies: 1
    Last Post: 11-16-2012, 09:25 AM
  5. Replies: 0
    Last Post: 03-29-2012, 05:45 AM
  6. Replies: 1
    Last Post: 01-17-2012, 10:47 AM
  7. Replies: 1
    Last Post: 02-19-2009, 03:00 AM

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