Print addresses on seperate pages for street

[Norm Dickinson]

I have address list in columns, consisting of up to forty streets. I
want to print all the address associated with one stree on seperate
pages with column header. The list is sorted by street name. The list
have an average of five hundered address.

I think process is:

Find the "Street" column cell where the street names change to a new
street name.

Add page break

Add Row

Paste column header titles in new row

Proceed until all streets are seperated and wll print on seperate
pages.


Norm.

 

[Bob Greenblatt]

I have address list in columns, consisting of up to forty streets. I
want to print all the address associated with one stree on seperate
pages with column header. The list is sorted by street name. The list
have an average of five hundered address.

I think process is:

Find the "Street" column cell where the street names change to a new
street name.

Add page break

Add Row

Paste column header titles in new row

Proceed until all streets are seperated and wll print on seperate
pages.


Norm.

You may not need to add rows of column headings. Look into Set Print titles.