You can use an AutoFilter to show only specific data from your table.
There are instructions in Excel's Help, and he

http://www.contextures.com/xlautofilter01.html

You could hide the fifth column, or set a print area that doesn't
include it.

hemi1 wrote:
I have 5 columns - i want to sort out 4 of them and then print into a new
document. For ex. i would sort based on col 2 (which contained codes 1, 2, 3,
and 4) i want to print all the data whose code begins with let's say 2; and
then maybe tomorrow I would need to print all the data whose code begins with
3, etc. based on my current needs.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html