Hi,
I have created the attached workbook and a macro which i am to roll up performance.
The issue i have is each day the data input will increase so a standardformula will not work.=Sumif
If you look at "Daily (Data)" i would like a formula in there which does a sumif but excludes brand. As stated above the current source data runs from row 2:19 but this will change on a daily basis. Is there any code which i can use to auto select the 1st section for the sumif calculation?
Kind Regards
Bookmarks