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

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.
Similar Threads
  1. tskelton75
    Replies:
    0
    Views:
    645
    tskelton75
    Nov 16, 2011
  2. tskelton75
    Replies:
    0
    Views:
    281
    tskelton75
    Nov 16, 2011
  3. jushin100
    Replies:
    1
    Views:
    993
    madonaalbert
    Jun 21, 2012
  4. peshy12
    Replies:
    1
    Views:
    851
    dallton
    Dec 31, 2012
  5. Crystal
    Replies:
    0
    Views:
    1,074
    Crystal
    Jul 11, 2014
  6. rx3210
    Replies:
    0
    Views:
    258
    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:
    419
    XLPadawan
    Jun 10, 2016
  8. Desiree Stevenson
    Replies:
    0
    Views:
    211
    Desiree Stevenson
    Aug 4, 2016
Loading...