Hi, I have this formula in a "Recap" sheet's B2 cell:
I can't share a sample with ease, too many sensitive data. But, as you can see/imagine, every month the workbook will receive a new YYYYMM sheet, and above formula will be updated with a new SUMIF('YYYYMM'!$C$2:$C$40;A2;'YYYYMM'!$J$2:$J$40)+ block. So, apart from the name of the sheets it takes info from (YYYYMM), the rest of the formula is static.Please Login or Register to view this content.
I was just wondering if there is a way of "upgrading" the formula automatically, without VBA, e.g. "compacting" it.
Thank you!
Bookmarks