SUM of MULTIPLE Column with same Header Name

Qavi

New Member
Joined
Feb 3, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
Hello Gurus!!
Dear Sirs,

I'm new to Macros in Excel, i work as an Accountant, I have a situation where i need to summarize the data on the scenario below mentioned in terms of points.


1.I have a Workbook with 12 Sheets (each month of year, from Jan to Dec)
2.I have 195 Columns (Maximum) per sheet (Jan 195 Columns, Feb - 177 Columns & so on...)
3.My data for calculation starts from Column 10(J) in each sheet
4.I have 2 Headers, 1st Header is Day of the month (01,02,03...28/31)
5.Each Day has a subheader under which there are 6 Columns with Subheader (G, D, M, F, C, O), for each day it will repeat
6. I want to SUM all the columns with G as SUBHEADER to column 4(D) -->A(subheader), D as SUBHEADER to column 5(E) -->B(subheader), M as SUBHEADER to column 6(F) -->C(subheader), F as SUBHEADER to column 7(G) -->D(subheader), C as SUBHEADER to column 8(H) -->E(subheader), O as SUBHEADER to column 9(I) -->F(subheader)
7.It must add all the existing rows in the sheet
8.It must repeat (iterate) for all the existing worksheets (12 Sheets)

for ex, in Jan month there are 31 times "G" columns and the rest of all columns comes 31 times.
hope I tried to express my requirement.

I want to RUN MACRO in excel, kindly need MACRO COde, I really appreciate your help with this.
i have attached the screenshot of the sheet to understand my scenario.

Thanks in Advance
Qavi
 

Attachments

  • SShot.jpg
    SShot.jpg
    237.5 KB · Views: 5

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Qavi

New Member
Joined
Feb 3, 2021
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
Uploaded proper sheet , showing the Sheet names in the Tab
 

Attachments

  • SShot.jpg
    SShot.jpg
    248.2 KB · Views: 2

Watch MrExcel Video

Forum statistics

Threads
1,127,613
Messages
5,625,848
Members
416,139
Latest member
MattBoard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top