Hi there,
Anyone please help me with my script how to minimise my current code by using Array function.
I can able to get the results with the current code. But I have to extract results into more than 100 columns. So I need to write more than 100 lines into my script.
For ease of understanding here I gave only very few rows of my script and attached sample excel macro sheet.
Sum of rows values depends on criteria (Specific text in column A) need to extract into specific column range.
For example if Text Criteria is “00” in column A then sum of values should paste into range E3, if Text Criteria is “01” in column A then sum of values should paste into range F3, if Text Criteria is “05” in column A then sum of values should paste into range J3.
Bookmarks