Printing a page with cell info

  • Thread starter Thread starter eyecalibrate
  • Start date Start date
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
 
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."
 
Back
Top