auto select cells to print
 

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 DataFilterAutofilter 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
wrote:

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.