print a column across a page

[NOtoUCE]

A stamp seller's list has Country Name in column A and Scott Catalog # in
column B. He wants to print customer order sheets of just the Catalog # in 8
columns across the page, and have the name of the country inserted whenever
the country changes.

The print-out would look something like this:
("#" would be replaced by the actual catalog number)
---------------------------------------------------------------------------

Afghan # # # # # # Bahama
# # # # Austra # # #
# Antigu # # # # # #
# # # # # # # #
# # # # # # # #
# # # # # # # #
# # Argent # # # # #
# # # # # # # #
# # # # # # # Bahrai
Angola # # # # # # #
# # # # # Austri # #
# # # # # # # #

etc.

 

[Guest]

If you could send me a dummy spreadsheet, I will write a
macro or userform. A dummy sheet may comprise of only a
few lines. Visit http://au.geocities.com/excelmarksway for
some of my handiwork.

Regards
Mark E. Philpot
[email protected]