Malleshg24
New Member
Hi Team,
In a attached Macro and its input file , I am getting correct result however I want to make a code dynamic.
In mapping sheet which is beside Macro tab , Colum ABC is a Template,
Cost Center Description is standard and Fixed. I copy the template and create new workbook for output.
Fill up the fill up output workbook with sumifs formula.
Can you suggest better way of doing the same task, or any other method \ can we minimize the code. using single function. or by looping.
Cost Center Description
Basic Basic Arr Basic
City Compensatory Allowan City Compensatory Allowan Arr CCA
In a attached Macro and its input file , I am getting correct result however I want to make a code dynamic.
In mapping sheet which is beside Macro tab , Colum ABC is a Template,
Cost Center Description is standard and Fixed. I copy the template and create new workbook for output.
Fill up the fill up output workbook with sumifs formula.
Can you suggest better way of doing the same task, or any other method \ can we minimize the code. using single function. or by looping.
Cost Center Description
Basic Basic Arr Basic
City Compensatory Allowan City Compensatory Allowan Arr CCA