Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2003 Special Output Formatting 1

Status
Not open for further replies.

dennycsr

MIS
Aug 4, 2001
13
0
0
US
I have an order form that the client chooses items to built the product. There may be 200 lines of options of which only 20 may be requested. I only want to printout the header info and the lines chosen. How can I accomplish this?
 
Data / Filter / Autofilter on non blanks on any column that will only have data in when the option has been chosen.

Regards
Ken..............

----------------------------------------------------------------------------
[peace]It's easier to beg forgiveness than ask permission[2thumbsup]
----------------------------------------------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top