Announcement

Collapse
No announcement yet.

MS Excel Custom Printing

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MS Excel Custom Printing

    So,

    Here's a question for you geniuses (or is it genii?)

    Is there a way to get Excel to print only those rows that have a value in a particular cell? An example might be a simple stock and the suer of that list wants to print a report from it but only those rows above a certain value (or below) e.g.

    Item 01 ... 0
    Item 02 ... 2
    Item 03 ... 1
    Item 04 ... 0
    Item 05 ... 1

    In the above example the following would be the printout:

    Item 02 ... 2
    Item 03 ... 1
    Item 05 ... 1

    Any ideas?

    Keke
    J C Rocks (An Aspiring Author's Journey)
    The Abyssal Void War: Stars, Hide Your Fires

  • #2
    Filter the worksheet and print only the visible rows?
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X