I have a file that has 2 tabs. Every week, I add a block of data into the tab labeled "importedData" by pasting the data for the respective days in the bottom rows. After that I need to add the sum of the new data in the "Summary" tab. I have been manually updating the formulas but I'm sure there's a more efficient/dynamic way to update the data.
My question: Is there a way to automatically update the data in the Summary tab as soon as I add data block in the bottom rows of the importedData tab. If you look at the file attached, my request will make more sense.