SUM cells with a specific column header from multiple worksheets - Using VBA

[crysperez]

Hi all,

I'm new to VBA and I'm seeking some assistance with a macro. I have a workbook with multiple sheets and I would like to sum all cells below a specific column header named, "Total Usage." The column is dynamic in position (doesn't always fall under the same column or row) and can appear multiple times in a single worksheet.

Is there a way to find the term "Total Usage" and sum all cells that fall under that column header? I'd also like the sum to appear in the first sheet (summary sheet).

Please let me know if I can provide any additional details to help with my request.

Thanks in advance for your help!

 

[Oeldere]

another approach.

Why not all data on 1 sheet.

After that you can easily analyze the data (e.g. with an pivot table).

 

[crysperez]

Hi Oeldere,

The workbook can contain an enormous amount of data so I thought a macro would be more efficient. I unfortunately don't have the resources to merge all the data onto 1 sheet.

Thanks!