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:
    24
    Likes Received:
    8
    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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tskelton75
    Replies:
    0
    Views:
    613
    tskelton75
    Nov 16, 2011
  2. tskelton75
    Replies:
    0
    Views:
    252
    tskelton75
    Nov 16, 2011
  3. jushin100
    Replies:
    1
    Views:
    959
    madonaalbert
    Jun 21, 2012
  4. peshy12
    Replies:
    1
    Views:
    820
    dallton
    Dec 31, 2012
  5. Crystal
    Replies:
    0
    Views:
    1,037
    Crystal
    Jul 11, 2014
  6. rx3210
    Replies:
    0
    Views:
    227
    rx3210
    Nov 10, 2014
  7. Kyle Hinterman

    How to paste the same cell one tab over

    Kyle Hinterman, Nov 20, 2015, in forum: Excel
    Replies:
    1
    Views:
    375
    XLPadawan
    Jun 10, 2016
  8. Desiree Stevenson
    Replies:
    0
    Views:
    167
    Desiree Stevenson
    Aug 4, 2016
Loading...