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
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