Qavi
02-03-2021, 07:55 AM
Dear VBA Gurus,
sir, I'm new to macros in excel. i dont have any knowledge of programming, I work as a Jr.Accountant , i have a situation to prepare the SUMMARISED DATA based on the sheets in excel file. ill list details of the sheet content in POINTS BELOW.
1.I have a excel file 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 SUBHEADER under which there are 6 Columns with SUBHEADING (G,D,M,F,C,O), for each day it will repeat
6. I want to SUM all the columns with G as Subheader from J to last column and post its SUM in Column 4(D) ,
D as SUBHEADER from J to last column and post its SUM in Column 5(E),
M as SUBHEADER from J to last column and post its SUM in Column 6(F),
F as SUBHEADER from J to last column and post its SUM in Column 7(G),
C as SUBHEADER from J to last column and post its SUM in Column 58(H),
O as SUBHEADER to from J to last column and post its SUM in Column 9(I)
7.It must add all the existing rows in the sheet
8.It must repeat for all the Sheets (12 Sheets)
for ex, in Jan month there are 31 times G Column and the rest of all columns come 31 times.
I'm introduced to MACROS in excel for the first time.
hope you understand my question (in points),
Kindly I request you to provide me with the VBA code.
i have attached the screenshot of the excel sheet.
Thanks
Qavi
sir, I'm new to macros in excel. i dont have any knowledge of programming, I work as a Jr.Accountant , i have a situation to prepare the SUMMARISED DATA based on the sheets in excel file. ill list details of the sheet content in POINTS BELOW.
1.I have a excel file 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 SUBHEADER under which there are 6 Columns with SUBHEADING (G,D,M,F,C,O), for each day it will repeat
6. I want to SUM all the columns with G as Subheader from J to last column and post its SUM in Column 4(D) ,
D as SUBHEADER from J to last column and post its SUM in Column 5(E),
M as SUBHEADER from J to last column and post its SUM in Column 6(F),
F as SUBHEADER from J to last column and post its SUM in Column 7(G),
C as SUBHEADER from J to last column and post its SUM in Column 58(H),
O as SUBHEADER to from J to last column and post its SUM in Column 9(I)
7.It must add all the existing rows in the sheet
8.It must repeat for all the Sheets (12 Sheets)
for ex, in Jan month there are 31 times G Column and the rest of all columns come 31 times.
I'm introduced to MACROS in excel for the first time.
hope you understand my question (in points),
Kindly I request you to provide me with the VBA code.
i have attached the screenshot of the excel sheet.
Thanks
Qavi