fastball16
New member
- Local time
- Today, 09:49
- Joined
- May 9, 2012
- Messages
- 3
Question:
I have a yearly listing crosstab. User can transfer/export a one year or multiple year listing of sales and cost of sales to Excel.
After my transferspreadsheet cmd, I have a formatExcel procedure that will format the header, change the columns to 'comma' format, and add a total row below the data.
I'm having an issue with adding the totals row. The numbers will always start on Column D and could go out to Column AJ at the most.
What is the best way to have VBA start at Column D and loop through the last column and insert the total for the given year/sales or year/cost columns?
Thanks.
I have a yearly listing crosstab. User can transfer/export a one year or multiple year listing of sales and cost of sales to Excel.
After my transferspreadsheet cmd, I have a formatExcel procedure that will format the header, change the columns to 'comma' format, and add a total row below the data.
I'm having an issue with adding the totals row. The numbers will always start on Column D and could go out to Column AJ at the most.
What is the best way to have VBA start at Column D and loop through the last column and insert the total for the given year/sales or year/cost columns?
Thanks.
