dfenton21
03-07-2010, 01:12 PM
Hi all,
From another system I export an expenses report into Excel. It appears in a simple table format with a category, items and costs.
I need that information to be displayed in a report format - i.e. make a heading from each category and place the items and costs underneath that heading.
I would also require the code to:
(1) Make the headings bold
(2) Indent the items one place (not in example below)
(3) sort each group by cost in descending order. (not in example below)
Please see http://www.mrexcel.com/forum/showthread.php?t=453218 for an example.
I would really appreciate someone's help with this. Sadly my VBA skills havn't reached this level yet.
Thanks
From another system I export an expenses report into Excel. It appears in a simple table format with a category, items and costs.
I need that information to be displayed in a report format - i.e. make a heading from each category and place the items and costs underneath that heading.
I would also require the code to:
(1) Make the headings bold
(2) Indent the items one place (not in example below)
(3) sort each group by cost in descending order. (not in example below)
Please see http://www.mrexcel.com/forum/showthread.php?t=453218 for an example.
I would really appreciate someone's help with this. Sadly my VBA skills havn't reached this level yet.
Thanks