select data and print in a new excel document

[Guest]

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.

 

[Anne Troy]

Seems to me you should maybe consider a mail merge. Then you won't have to
mess with your Excel file so much.
http://www.officearticles.com/word/mail_merge_letters_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Debra Dalgleish]

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

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

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