Forum Discussion

Leo bergen's avatar
Leo bergen
Copper Contributor
Sep 21, 2017

Linking Sheets

Good Afternoon,

 

My dilemma. I have over 30 roster sheets. I need to create a master sheet from those rosters sheets. Once that is done, I would like to update my roster sheets, and those updates will automatically be  reflected unto the Master sheet.

 

Any help will do please.

 

Thank you in advance

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Leo,

     

    Power Query (Get & Transform in 2016) looks like a right solution for that.

Resources