+ Reply to Thread
Results 1 to 5 of 5

Mirror excel

  1. #1
    Registered User
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    48

    Mirror excel

    Is there a way that I can mirror an excel workbook into another workbook? All the things that I've done in workbook1 will be updated in workbook2? This will includes excel formulas, VBA codes, macros, formatting, deleting/adding of data, etc.

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,699

    Re: Mirror excel

    Why 2 workbooks that are the same?

    first:
    Save workbook1 as workbook1

    then:
    Save workbook1 as workbook2
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,531

    Re: Mirror excel

    If you need to see both side by side as you work...

    View ribbon tool -> New Window

    It will replicate workbook in two separate window (single instance). So when you save it will be just one workbook, to save a copy just follow direction from Willem.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    08-18-2018
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    48

    Re: Mirror excel

    I need to make the workbook1 as the master file or backend file and the workbook2 is the file that the users will use as the frontend file. So anytime that I make changes in the workbook1 will automatically change/update in workbook2.

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,531

    Re: Mirror excel

    Then you need to think of ways to link the two.

    1. Via some query/connection. Set to refresh at interval.

    2. Linked formula.

    Etc.

    However, set up will depend on how you are using the data. And if link direction is one way or not.
    In general, it is recommended that you use proper relational database for this sort of application (ex: MS Access, SQL Express etc) as back end. MS Access can serve as front-end or you can use Excel. As Excel isn't designed for data integrity and can have multiple issue in this type of set up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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