Posts by isanka88

    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!