malleshg24
06-07-2020, 04:46 PM
Hi Team,
I have attached my Macro with Input File,
Macro gives correct result. but the code is not dynamic.
Need your help in creating Single custom Sumifs Formula , (Criteria ,sumranges and header, parameter should pass from Mapping sheet.)
I want result as per Mapping sheet, Macro will find header sum those headers range , as per cost center description.
I have taken few *Cost Center Description) as an example, list is lenghty, header to sum max there will be 4 headers.
Thanks in advance for your help.
mg
I have attached my Macro with Input File,
Macro gives correct result. but the code is not dynamic.
Need your help in creating Single custom Sumifs Formula , (Criteria ,sumranges and header, parameter should pass from Mapping sheet.)
I want result as per Mapping sheet, Macro will find header sum those headers range , as per cost center description.
I have taken few *Cost Center Description) as an example, list is lenghty, header to sum max there will be 4 headers.
Thanks in advance for your help.
mg