Forum Discussion
help referencing data from large spreadsheet to summary sheet
I have a large, detailed spreadsheet with data such as attendance and donations listed by week. This workbook has a separate tab for each year, rows are each week's date, and columns for each week's...
MaryR1330 There are different ways to go about this. The best next step is to send over your file, removing any sensitive data, for us to test out different methods of how to create a dynamic reference in your Summary tab. One immediate change would be to apply a SUMIF function that changes the weeks being summed together based on the current time, to avoid having to manually sum each tabs figures.