create a "packing slip" from excel 2

[creeker69]

Is there a way (other than AUTO FILTER) to have Excel print a packing slip? I have a very large excel sheet.

O.H. PART-NO DESC BIN
2 12455 pump SHELF20
3 16490 gasket SHELF20

I would like to have Excel print each BIN separately without having to AUTOFILTER each BIN because of the large amount of different BINs on the sheet.

My goal is to print each sheet by BIN and when the BIN changes, start a new sheet, and so on.

Any ideas?

Thanks in advance!

 

[SkipVought]

Hi,

You could use the Data/Subtotal feature, selecting the Pabe Break Between Groups checkbox, then print.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[creeker69]

Thanks Skip! I have used SubTotals before but just for viewing. I never notcied the PAGE BREAK feature. That does it exactly! A star for you and thanks for the quick reply!

Ron

 

[DeLaMartre]

Very interesting, Skip! I tried it out and it works like a charm. Not sure what I will ever do with this, but you never know.

Another star.

Thanks,

-Bob in California