Anki Wrote:
what about go to data, filters, autofilter...that would turn on the
filters
on all handers (you should see in the first line, there are black
triangles
allow you to click and show all the cell values populated in that
column).
Go to the column where it specifies the key (like your job name) and it
will
display rows with that key only. The other rows would be hidden, not
deleted. And it will print the displayed rows only.

When you are done and would like to reset, you can pull the filter
menu
again and select 'all'. Or simply turn off the filters (again...data,
filters, autofilter)


Thank you, works great!


--
sakk555
------------------------------------------------------------------------
sakk555's Profile: http://www.excelforum.com/member.php...o&userid=24042
View this thread: http://www.excelforum.com/showthread...hreadid=376527