A
azu_daioh
I have a rollup worksheet and using a macro it gathers all the VOL and
MIN columns from the other worksheets onto the rollup worksheet. But
I would like to add a GRAND TOTAL VOL and GRAND TOTAL MIN on the
rollup worksheet.
Before the macro is run, the rollup worksheet contains the following
columns where A and B corresponds to the column letter.
A: Grand Total Vol
B: Grand Total Min
After the macro is run, the rollup worksheet will have the following
column headings:
A: Grand Total Vol
B: Grand Total Min
C: 202 VOL
D: 202 MIN
E: 203 VOL
F: 203 MIN
G: 204 VOL
H: 204 MIN
I would like to be able to display the grand total on each row for VOL
and MIN. How do I formulate it without doing it manually (Grand
Total Vol =C1+E1+G1+I1+K1...)??
Thanks for the help,
Sharon
MIN columns from the other worksheets onto the rollup worksheet. But
I would like to add a GRAND TOTAL VOL and GRAND TOTAL MIN on the
rollup worksheet.
Before the macro is run, the rollup worksheet contains the following
columns where A and B corresponds to the column letter.
A: Grand Total Vol
B: Grand Total Min
After the macro is run, the rollup worksheet will have the following
column headings:
A: Grand Total Vol
B: Grand Total Min
C: 202 VOL
D: 202 MIN
E: 203 VOL
F: 203 MIN
G: 204 VOL
H: 204 MIN
I would like to be able to display the grand total on each row for VOL
and MIN. How do I formulate it without doing it manually (Grand
Total Vol =C1+E1+G1+I1+K1...)??
Thanks for the help,
Sharon