Creating Spreadsheet Reports

  • Thread starter Thread starter Webtechie
  • Start date Start date
W

Webtechie

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
 
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
 
Back
Top