Thread: Print only rows with data entered in an excel template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Print only rows with data entered in an excel template
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

On Sat, 9 Aug 2008 04:09:00 -0700, hellaby
wrote:

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

Reply With QuoteReply With Quote