Only print the filled cells?

[Hamidam]

Hi, I am doing an ordering excel "tool" , where its possible to orde
among tousands of products.

I would like to as the user chooses to print the orderinglist, only th
filled cells should be printed, and not 100 pages, understand?

The orders are daily and the user threats like about 20 companys at th
same time, so if C2 (C1 = "Company 1") is filled and D5 (D1="Company 2
then i would like the produkts on A2 and A5 with those companys printe
automatically...

I understand you can use autofilter, but then the (dumb) use
would have to do it every time, print , and change all of them back t
normal again...


Thanks / Jennife

 

[Dave Peterson]

Maybe you could record a macro that:
uses autofilter to hide the rows you don't want printed
prints the worksheet
unhides the rows

You could record a macro when you do it once, then drop a button from the Forms
toolbar onto that sheet. And assign your macro to that button.

 

[Hamidam]

I always wondered what a macro is and now i know!

But unfortanly, crap windows (microsoft) doesn't allow more than on
active window, so if I push the print button i can't stop the macr
unless i press cancel or print... so the options for the printe
disappears... but if I don't find any other way your's is useful ..
thanks alot / Jennife

 

[Hamidam]

you wrote "then drop a button from the Form
toolbar onto that sheet. And assign your macro to that button.

drop a button from the Forms toolbar onto that sheet?

I have only succeded into dropping a button among the other icons (i.
bold, zoom and those icons, when I choose adjust(? don't have th
english version) after rightklicking on for example bold, chooses th
option at the bottom of that list (adjust?) )

and not onto the sheet... and I guess that if the files is run on som
other computer that button won't be there right

Thanks / Jennife

Edit... ok... now i get it... haha... always to late! thanks Dave

 

[Dave Peterson]

Show the Forms toolbar
(View|toolbars|check Form)

click on the button icon and draw a button on the worksheet itself--not in the
toolbar area.

I like to freeze windows so that row 1 is always visible and put the buttons in
that area.