multiple subtotals
 

On my boss's monthly credit card report, each expense receives a keycode
(funding source) and object code (type of expense). I need subtotals of each
keycode/object code combination. Suggestions? Many thanks.
--
m

multiple subtotals
 

Hi,

You may create a pivot table. Drag keycode and object code to the row area
and amount to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marion J" wrote in message
...
On my boss's monthly credit card report, each expense receives a keycode
(funding source) and object code (type of expense). I need subtotals of
each
keycode/object code combination. Suggestions? Many thanks.
--
m

multiple subtotals
 

I think this will work and that you are a genius. Many thanks.
--
m


"Ashish Mathur" wrote:

Hi,

You may create a pivot table. Drag keycode and object code to the row area
and amount to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marion J" wrote in message
...
On my boss's monthly credit card report, each expense receives a keycode
(funding source) and object code (type of expense). I need subtotals of
each
keycode/object code combination. Suggestions? Many thanks.
--
m

multiple subtotals
 

I think this works and that you are a genius!! Many thanks!
--
m


"Ashish Mathur" wrote:

Hi,

You may create a pivot table. Drag keycode and object code to the row area
and amount to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marion J" wrote in message
...
On my boss's monthly credit card report, each expense receives a keycode
(funding source) and object code (type of expense). I need subtotals of
each
keycode/object code combination. Suggestions? Many thanks.
--
m

multiple subtotals
 

Thank you for the feedback

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marion J" wrote in message
...
I think this will work and that you are a genius. Many thanks.
--
m


"Ashish Mathur" wrote:

Hi,

You may create a pivot table. Drag keycode and object code to the row
area
and amount to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Marion J" wrote in message
...
On my boss's monthly credit card report, each expense receives a
keycode
(funding source) and object code (type of expense). I need subtotals of
each
keycode/object code combination. Suggestions? Many thanks.
--
m