Way to create a copy of a record before it gets modified - Page 2
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: Way to create a copy of a record before it gets modified

  1. #11
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    15,763
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Way to create a copy of a record before it gets modified

     
    Just as a note, the simplest thing to do is just create a copy of the original data, and then let users/clients have at it on the data (which can be considered Version 1 - the original and Version 2 - the updated or editable version).

    Actually, I would be versioning all of the budgets because even when you start a new one next year or next quarter you still probably want to keep the prior budgets from previous years. Basically, a budget or a forecast should have an ID, and some budgets should be "done" while others are "in progress" (speaking from experience, anyway - forecasts take time to work out, even if you are very good at it, and at some point in time will be 25% done, 50% done, 75% done and so on, especially if input comes from various sources and needs to be put together).
    Last edited by xenou; Nov 30th, 2017 at 05:17 PM.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com