ExcelBanter - Creating Spreadsheet Reports

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Creating Spreadsheet Reports (https://www.excelbanter.com/excel-discussion-misc-queries/238850-creating-spreadsheet-reports.html)

Creating Spreadsheet Reports

Hello,

I have developed a big spreadsheet complete with userforms and lots of vba
code. The userforms query and get the information keyed in nicely.

Now I want to create reports in Excel. Is the only answer to ship over to
Crystal Reports. Can't you do reports in Excel?

1) I know how to create header and footer
2) Can you group or sort a report in Excel?
3) Anyone know of reporting capabililites other than repeating columns and
rows?

Thanks,

Tony

Creating Spreadsheet Reports

You can use Excel's filtering functions.

Or Data Group and Outline.

Also check out Custom Views to set up printing views.

Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 07:57:01 -0700, Webtechie
wrote:

Hello,

I have developed a big spreadsheet complete with userforms and lots of vba
code. The userforms query and get the information keyed in nicely.

Now I want to create reports in Excel. Is the only answer to ship over to
Crystal Reports. Can't you do reports in Excel?

1) I know how to create header and footer
2) Can you group or sort a report in Excel?
3) Anyone know of reporting capabililites other than repeating columns and
rows?

Thanks,

Tony