auto select cells to print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Working on a quote worksheet, with several items and prices. Simply will
only enter certain qty's by certain items and the extended cost will be
calculated. Simple at this point. Now to click a button and only print
those items that have a qty entered. Wth the qty, desc and exteded cost.
 
"Auto" usually involves VBA code.

Record a macro as you Data>Filter>Autofilter and print the results of that
filtering which presumably would be rows with qty entered.

Assign that macro to a button.


Gord Dibben Excel MVP

On Tue, 10 May 2005 11:30:04 -0700, "Conrad ICR" <Conrad
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calcs & Data Validation 3
Conditional format cell for $0 4
Delete colomns and rows 1
reference cells on one tab by value of cell on other tab 5
Compare to two sheets in one excel file to evaluate and combine whereidentical. 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Finding maximum qty of items to reach given limit 1
printing blank forms with auto generated numbers 4

Back
Top