I have a spreadsheet with about a thousand rows and several columns that have the same header titles. E.g. Principal in column AD, AG and AJ etc. Is there a macro that I can use to detect the header title and sum the values in the cells by row?
I have a spreadsheet with about a thousand rows and several columns that have the same header titles. E.g. Principal in column AD, AG and AJ etc. Is there a macro that I can use to detect the header title and sum the values in the cells by row?