Displaying all rows, printing only certain rows
 

Hi,

I have a sheet that is printed out on a daily basis which is basically a
list of tasks to do.

Some of the tasks only run on certain days and not others, some tasks are
done everyday.

Basically what I would like to do is when the worksheet is open on screen,
it displays all rows for editing etc, but when I print the worksheet out, it
only prints rows relevant for that day and hides the rows not relevant.

Any help would be greatly appreciated.

Thanks.

Displaying all rows, printing only certain rows
 

I think I'd apply Data|Filter|autofilter to that range.

Then right before I print filter on the date column to show just the dates in
which I'm interested. Then print those visible rows and then
data|Filter|showall to see everything after the print.

GLT wrote:

Hi,

I have a sheet that is printed out on a daily basis which is basically a
list of tasks to do.

Some of the tasks only run on certain days and not others, some tasks are
done everyday.

Basically what I would like to do is when the worksheet is open on screen,
it displays all rows for editing etc, but when I print the worksheet out, it
only prints rows relevant for that day and hides the rows not relevant.

Any help would be greatly appreciated.

Thanks.

--

Dave Peterson

Displaying all rows, printing only certain rows
 

Hi Dave,

yes thats what I wound up doing, adding an extra column and then running an
auto filter - is there a way to set this up so that it hides a column, prints
the document, then unhides it again?

"Dave Peterson" wrote:

I think I'd apply Data|Filter|autofilter to that range.

Then right before I print filter on the date column to show just the dates in
which I'm interested. Then print those visible rows and then
data|Filter|showall to see everything after the print.

GLT wrote:

Hi,

I have a sheet that is printed out on a daily basis which is basically a
list of tasks to do.

Some of the tasks only run on certain days and not others, some tasks are
done everyday.

Basically what I would like to do is when the worksheet is open on screen,
it displays all rows for editing etc, but when I print the worksheet out, it
only prints rows relevant for that day and hides the rows not relevant.

Any help would be greatly appreciated.

Thanks.

--

Dave Peterson

Displaying all rows, printing only certain rows
 

How about sticking that column in Column A.

Then use file|Page setup|sheet tab to specify your range--and don't include
column A.

(You could also put it to the right, too)

But if you want, you could have a macro that hides the column, prints the sheet,
and unhides the column:

Option Explicit
Sub testme03()

With Worksheets("sheet2")
.Range("e1").EntireColumn.Hidden = True
.PrintOut preview:=True
.Range("e1").EntireColumn.Hidden = False
End With

End Sub

(I used preview:=true to save a few trees while testing.)

GLT wrote:

Hi Dave,

yes thats what I wound up doing, adding an extra column and then running an
auto filter - is there a way to set this up so that it hides a column, prints
the document, then unhides it again?

"Dave Peterson" wrote:

I think I'd apply Data|Filter|autofilter to that range.

Then right before I print filter on the date column to show just the dates in
which I'm interested. Then print those visible rows and then
data|Filter|showall to see everything after the print.

GLT wrote:

Hi,

I have a sheet that is printed out on a daily basis which is basically a
list of tasks to do.

Some of the tasks only run on certain days and not others, some tasks are
done everyday.

Basically what I would like to do is when the worksheet is open on screen,
it displays all rows for editing etc, but when I print the worksheet out, it
only prints rows relevant for that day and hides the rows not relevant.

Any help would be greatly appreciated.

Thanks.

--

Dave Peterson


--

Dave Peterson