Print only rows with data entered in an excel template

[hellaby]

I have a purchase order template that can be of variable length. How can I
print only lines with data entered in?

 

[Gord Dibben]

Set up a dynamic print range.

See Debra Dalgleish's site for creating and naming dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP