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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transfer the data from userform to spreadsheet for specific dates 0
userform for spreadsheet 1
Multiple reports 2
Excel Excel 2007 fails on insert userform 0
Report 1
automatically deleting blank rows? 3
How do you embed Access Report in Excel? 3
Excel vs Access 4

Back
Top