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

--
Message posted from http://www.ExcelForum.com