Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Excel report
I need to a simple report out of excel to basically show one row of data on
one page. For example; I'm looking at 50 cars (rows) with 20 criteris (columns) and I want to print one page per car (row). Any ideas would be helpful. Already downloaded Report Manager and took a look at pivot tablel; but they dont seem to help. Thanks, JJA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple Excel report
You could use a macro that hides the all the rows and then prints that row.
Then it goes to the next row and does the same. Option Explicit Sub testme01() Dim FirstRow As Long Dim LastRow As Long Dim iRow As Long With Worksheets("sheet1") FirstRow = 2 LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For iRow = FirstRow To LastRow 'hide all the rows .Rows.Hidden = True 'do you need the header row printed? .Rows(1).Hidden = False .Rows(iRow).Hidden = False .PrintOut Preview:=True Next iRow 'unhide all the rows .Rows.Hidden = False End With End Sub I used column A to determine the number of rows to print. And I printed both row 1 (always) and each row. Just delete that .rows(1).hidden line if you don't want the headers. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm JJA wrote: I need to a simple report out of excel to basically show one row of data on one page. For example; I'm looking at 50 cars (rows) with 20 criteris (columns) and I want to print one page per car (row). Any ideas would be helpful. Already downloaded Report Manager and took a look at pivot tablel; but they dont seem to help. Thanks, JJA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When running a SAP report Excel will only display results if Excel isn't already open | Excel Discussion (Misc queries) | |||
Where do I find Report Manager for Excel 2003? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
New Excel user needs help with simple Macro... | New Users to Excel | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |