Printing selected data

  • Thread starter Thread starter OTG
  • Start date Start date
O

OTG

Hello,
Using Excel 97, I have set up a spreadsheet that has about three pages
of data. Columns A through D give item description. Columns E through J
have been left blank so as to let other people enter the quantities they
need.
My problem is this: I need to be able to print out only rows that have
quanitites entered in columns E through J. I don't want to print out the
entire list of three pages.
I have tried Advanced Filter, which works reasonably well, however other
people with less computer skills will also be printing, so it must be
made simple to use.
Is there a macro, function, format or anything else that I could use?
Thanks in advance.
 
How about using a helper column and Data|Autofilter.

Insert a new column (column A) and make sure you don't include that in your
print range. (or use one to the far right???).

Then a formula like:

=if(counta(F2:K2)=0,"hide","show")

(I moved E:J to F:K)

Then filter to show only the shows.
Print the worksheet and data|filter|showall

And if you apply the filter to the whole range, you might even make it more
useful to the users!
 
Back
Top