Printing a page with cell info

E

eyecalibrate

Owner Tool # Condition
Dave 601 Good
Phil 1701 Poor
Steve 4545 Excellent

I have a spreadsheet (larger) but similar to the above illustration.
enter data...Dave...601...Good.... When I get to the end of the ro
I'm on a blank cell. At this point I want to run a macro (with a ho
button which I already know how to install) which will send data fro
the cells in that row directly to my printer without going to
template or any other document. I don't want it to print out i
"spreadsheet" form. I want to be able to center align the text an
embed redundant text which isn't in the row's cells; as in th
following example:

The owner of the tool is Dave.
Tool number 601 has passed inspection.
It is in Good shape.

Can anyone help me in my quest?

Thank you in advance,

Eyecalibrat
 
R

Rob van Gelder

An idea might be to write a formula for each row and make that cell the
Printable area.

So, in D1 you enter a number. 0 for row 1, 1 for row 2 etc..
E1:
="The owner of the tool is " & OFFSET(A1,D1,0) & ".
Tool number " & OFFSET(B1,D1,0) & " has passed inspection.
It is in " & OFFSET(C1,D1,0) & " shape."
 
Top