Forum Discussion

Amanda Messenger's avatar
Amanda Messenger
Copper Contributor
Aug 14, 2017

Connecting Excel Sheets

So, I'm not sure if this is something I can do or not.

 

I help run a club and each member of the organization has their own spreadsheet that tracks what events they go to. 

 

So, for example,

 

Event 1

Event 2

Event 3

 

Now, is there a way that I can make 1 Event Sheet as a base and when I make changes to that 1 sheet, it will automatically update and make that same change to the rest of the sheets? Like if I delete an event off of one, it will delete off all of them?

 

Thanks,

Amanda

excel

1 Reply

  • Brian Spiller's avatar
    Brian Spiller
    Brass Contributor
    Sep 09, 2017

    I would not have multiple sheets with the data. Use only one sheet for the data and then use the reporting Tools to provide the details for each Member.

     

    For the Report side there are a number of options. Pivot Tables is my first choice though using Advanced Filters is an option.

    With Excel 2013 and later, you could easily filter in Place if the data is in a proper Table using Table Slicers.