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

  • Hi All Good people

    I'm new to VBA and I'm seeking some assistance with a macro. I have a workbook with multiple sheets. First worksheet is call master worksheet. In the master worksheet I have sheet names. I would like to sum all cells below a specific column header named, "My text." across all my worksheets and insert the sum values in master sheet. For an example lets suppose I have 4 worksheets as Master, Shee1, Sheet2 and Sheet3. In the Master sheet I have each sheet names from A1 to C1. So I want the sum value below each of these sheet names. The sum value should pull from sheet 1, 2 & 3 based on heading name "My Text" But the column is dynamic in position (doesn't always fall under the same column or row)

    Is there a way to find the term "My text" and sum all cells that fall under that column header?

    Please let me know if I can provide any additional details to help with my request. I have attached my original workbook as below with my requirement explained on it…wDb1_C5Llb7eGOoDD1TH/view

    Thanks in advance for your help!

  • Hi gijsmo
    Superb!. It worked for me. I do not know how to say thank you for your valuable effort on this. My happiness is out of verbal definitions. Because of good people like you, I was able to successfully finish my project. Thank you very much and I owe you a lot.:love::love::love::love::love::love:.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!