I was tracking and comparing some values in an excel sheet that does sums a column. Fairly basic and straighforward, that sheet was then saved to represent a day in a given month. Now after about 6 months of this, i am told need to sum all the sheets. It isn't huge number, but over 10 or so different topics, 10-20 or so sheets a month, so cumulatively speaking, it is a lot.
Essentially I just want a new sheet that will look at all files in a given folder and add the value s found in say C12 in all the WBs. I was thinking of just making one for each month, and hoping it would then be able to go to look in the folder it resides, and any sub folders it finds and add up this specifc cell, which is the same in all the WB.
Excel 2010 if it matters.