I am compiling responses, the responses are coming in on an Excel sheet (two sheets per response). Is there a way to have a master spreadsheet, paste all the responses in to this spreadheet, and have a summary sheet automatically make tallies?
A1 on all the tabs hold a value, x tabs. Summary sheet adds all the values of A1. But here's the catch... automatically change the formula when more tabs are imported/ pasted?
Cliff: Excel sheet will grow over time, can I have a summary tab automatically add all the values in cell A1 across all the tabs, and placed in A1 of summary tab. If a tab is added, it will automatically get added to the SUM of A1 and placed in the summary.
A1 on all the tabs hold a value, x tabs. Summary sheet adds all the values of A1. But here's the catch... automatically change the formula when more tabs are imported/ pasted?
Cliff: Excel sheet will grow over time, can I have a summary tab automatically add all the values in cell A1 across all the tabs, and placed in A1 of summary tab. If a tab is added, it will automatically get added to the SUM of A1 and placed in the summary.