canada_user
03-04-2009, 03:48 PM
Hi,
I'm trying to write a macro that will total rows if the value in column A is the same (see attached - the top table is the raw dat, the table below it is how I'd like it to look). I know I can use a pivot or the subtotal function but a macro is since I'd like the data to be formatted as in a spreadsheet.
Thanks in advance.
I'm trying to write a macro that will total rows if the value in column A is the same (see attached - the top table is the raw dat, the table below it is how I'd like it to look). I know I can use a pivot or the subtotal function but a macro is since I'd like the data to be formatted as in a spreadsheet.
Thanks in advance.