+ Reply to Thread
Results 1 to 3 of 3

Automatic Update for duplicate workbook

  1. #1
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Automatic Update for duplicate workbook

    Hi,

    I wasn't sure which section to post it in.

    I have two workbooks, one for typing and doing work etc... and a duplicate workbook as back up.

    I used the
    Please Login or Register  to view this content.
    to get the values out of the main workbook to the duplicate workbook.

    But if I insert a new row or a new column, I need to go into the duplicate workbook and drag down or across the formula.

    Is there another way about it to cut out my time and update it automatically?

    Thanks

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,758

    Re: Automatic Update for duplicate workbook

    What if you accidently delete something from original book? it will also be deleted from the duplicate in this case

    The best way would be to create a back up of the master book after you finish working on it by "Save as" method.
    Teach me Excel VBA

  3. #3
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Re: Automatic Update for duplicate workbook

    Hi,
    I should of probably mentioned this:

    The back up is created with the following additional formula:
    Please Login or Register  to view this content.
    From there, the back up data is stored in a file and I will find a macro that extracts all the sheet data from duplicate back up data into a text file to save in a specific folder.

+ 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. Replies: 8
    Last Post: 10-15-2015, 07:55 AM
  2. [SOLVED] Automatic update pivottable in closed workbook and email macro
    By wrybel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2015, 09:16 AM
  3. Automatic Update to a Workbook from another workbook
    By chrisjack in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 03:04 PM
  4. Replies: 8
    Last Post: 05-02-2012, 10:35 PM
  5. Automatic update of a simple date row in a workbook template
    By excel_stuntman in forum Excel General
    Replies: 3
    Last Post: 04-19-2012, 01:40 PM
  6. Automatic update from one workbook to another workbook
    By ssunkanmis in forum Excel General
    Replies: 1
    Last Post: 06-25-2009, 02:42 PM
  7. Automatic update from different workbook
    By justinng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2009, 03:02 AM

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