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