select data and print in a new excel document

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.

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/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"hemi1" <[email protected]> wrote in message
news:[email protected]...
> 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.

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.

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