Need help with summary table

Question

Level 1

8 points

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

Reply

Answer 1

SGIII

Level 8

37,568 points

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

Reply

Answer 2

Gravacor Author

Level 1

8 points

Sep 23, 2016 5:55 PM in response to SGIII

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

Reply