Printing same cells as cover page

[ReTeMa]

hi,

i have excel xp file with columns
name - subject - city - street - telephone - fax etc., all together about 1.000 rows.

for example: i go to row 10 and want to print only name and subject as cover page with big & bold fonts.
just the same thing for any random selected row.

how? macro? some vba programming (in a new sheet) ?

thanks for any idea or solution.

 

[SkipVought]

Hi,

Filter the row/colunms you want and Print.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[ReTeMa]

thx skip
but this is not the solution.

any solution? no solution?

 

[Bogiemon]

Why don't you have another sheet that's formatted how you want the header page and when you do the print copy the name and subject over to this new sheet and print that.

 

[SkipVought]

Riddles are for non-technical forums.

"but this is not the solution."

WHY is this not the solution?

"any solution? no solution?"

What does this mean?

Please be clear! Please be complete! Please be specific!

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]