Gravacor

Q: Need help with summary table

I have a spreadsheet that has about 40 different sheets with each one being a person that lists info about each one and if they participated in a given event.

 

Is there a way to create a summary table that spans all sheets and can show participation based on the event? Sort of like a portal in a database. My struggle is being able to drag the formula down to auto change sheets. I don't want to have to individually type an if then formula with offset to plug in the number for each field.

Posted on Sep 23, 2016 11:32 AM

Close

Q: Need help with summary table

  • All replies
  • Helpful answers

  • by SGIII,Helpful

    SGIII SGIII Sep 23, 2016 5:52 PM in response to Gravacor
    Level 6 (10,796 points)
    Mac OS X
    Sep 23, 2016 5:52 PM in response to Gravacor

    You mention a portal on a database. I think you're on the right track. It's much easier to pull information together from one table than it is from dozens of tables. Why not keep your data all in one table database and "extract" information for a person from that table.

     

    If you could provide more details one what you are trying to do someone here will be able to give you more specific suggestions.

     

    SG

  • by Gravacor,

    Gravacor Gravacor Sep 23, 2016 5:55 PM in response to SGIII
    Level 1 (4 points)
    iWork
    Sep 23, 2016 5:55 PM in response to SGIII

    IMG_1026.JPG

     

    EAch individual has had their own tab of information and I'd like to creat a page that would allow me to pull from each tab into one summary. One in which I can just fill the formula and allow me

    tochoose what event It's from