I have an excel spreadsheet that I enter data on all month. At the end of the month I must extract that data and break it down into totals and put it on a separate spreadsheet. This spreadsheet holds data from 2008-2016. Like I said I'm only extracting one month of data but the problem is there is so much data. My question is:
Is there a way to get the data I'm entering on the big spreadsheet to automatically total on another total spreadsheet as I'm entering the data so at the end of the month the total report is complete?