Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Reports in another worksheet in a workbook | Excel Discussion (Misc queries) | |||
Creating reports that grow/shrink | Excel Discussion (Misc queries) | |||
Creating multiple reports from a database | Excel Discussion (Misc queries) | |||
Creating separate reports for each Project Manager | Excel Discussion (Misc queries) | |||
Creating Customize Reports | Excel Discussion (Misc queries) |