I want to produce a report in Excel based on a table. I've attempted this using a PivotTable but I hit a character limit in PivotTable. What other options can I use to produce a report based on criteria in Excel? I need to be easy to use and not require much work as the ultimate goal is to simplify reporting.
What I want to produce (with two criteria: select month/year & display only items with "Significant Accomplishments" flag) is a table like the one below. I need to be able to copy and paste the table into PowerPoint, Outlook email etc.
[TABLE="width: 250"]
<TBODY>[TR]
[TD][/TD]
[TD]Accomplishments
[/TD]
[/TR]
[TR]
[TD]Vendor 1
[/TD]
[TD]Cost savings of $500,00
[/TD]
[/TR]
[TR]
[TD]Vendor 2
[/TD]
[TD]Closed out outstanding customer complaints
[/TD]
[/TR]
[TR]
[TD]Vendor 3
[/TD]
[TD]Process improvement X saves 50 hours per week
[/TD]
[/TR]
</TBODY>[/TABLE]
What I want to produce (with two criteria: select month/year & display only items with "Significant Accomplishments" flag) is a table like the one below. I need to be able to copy and paste the table into PowerPoint, Outlook email etc.
[TABLE="width: 250"]
<TBODY>[TR]
[TD][/TD]
[TD]Accomplishments
[/TD]
[/TR]
[TR]
[TD]Vendor 1
[/TD]
[TD]Cost savings of $500,00
[/TD]
[/TR]
[TR]
[TD]Vendor 2
[/TD]
[TD]Closed out outstanding customer complaints
[/TD]
[/TR]
[TR]
[TD]Vendor 3
[/TD]
[TD]Process improvement X saves 50 hours per week
[/TD]
[/TR]
</TBODY>[/TABLE]
