Use a master workbook to carry over changes to multiple workbooks

Discussion in 'Excel' started by Maxwell, Oct 20, 2016.

  1. Maxwell

    Maxwell

    Joined:
    Oct 20, 2016
    Messages:
    1
    Likes Received:
    0
    I have a list of prices that is copied from a template onto all tabs in a workbook so any amendments to the template can be carried across to each tab (by grouping the tabs). As there are numerous different workbooks all with the same list I want to have a master that can be changed and carries across the changes on all workbooks without having to deal with workbooks individually and group and ungroup each time. Can anyone point me in the right direction?
     
    Maxwell, Oct 20, 2016
    #1
    1. Advertisements

  2. Maxwell

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    If you have a master workbook with the prices you can have them all reference that one workbook.
    Under the data menu click existing connections and then browse to the excel workbook with the master list of prices. You can have it load the data into one sheet in the second workbook and then refresh it as needed.
    Hope this helps
    Amy
     
    Amy @ German Pearls, Nov 15, 2016
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.