Problems With Sum function working when using macro to add in template

[neil__g]

Hi Everyone,

I have a macro that adds in a blank template into a table for users to fill out. This works great but the SUMIF at the bottom of the table isn't changing to take into account the increase in information.

I have attached the macro code and an example workbook.

Thanks.

Master Sheetexample.xlsm

Please Login or Register  to view this content.

[dilipandey]

Hi Neil,

See the attached file, yellow cell where I have used the dynamic names to achieve the desired result. thanks.
Master Sheetexample.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>

[neil__g]

Hi,

Thanks very much, however if you then try to use the forumla for other months it is still seeing the data in the April column, each month needs to be different, is this possible?

[dilipandey]

Yes.. this is possible.

Change the reference of first cell in the dynamic name and use that accordingly..
Press Alt + I + N +D to get name manager window.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>