Printing inventory

[Richard]

I have an inventory sheet that I use for reordering parts,I only want
the items on the sheet with a number to print. I can make it print just
the items needed but they are spread out over multiple pages ( some with
a single item) when printed. It probably is simple but beyond me.
Thanks

 

[Otto Moehrbach]

Richard
One way would be to use VBA to loop through all of your data and copy
only those rows that meet your criteria and paste those rows into your
inventory sheet. Then print that sheet. If this sounds like what you want,
post back and provide more details about the layout of your data in the
various sheets, including the inventory sheet. Also provide some insight
into what sheets you would want the VBA code to scan and which not to scan.
Clearly state what constitutes "items on the sheet with a number to print".
By "layout" I mean what columns hold what and what columns do you want the
code to look at. HTH Otto

 

[Gord Dibben]

What do you consider as a "page"?

If a worksheet within a workbook and you have several, you will have to
amalgamate somehow onto one sheet for printing.

If "pages" are multi-pages on one worksheet then you should be able to use
Autofilter for just numbers.


Gord Dibben MS Excel MVP

 

[Richard]

I'm sorry for not being more specific. I have a workbook with 3
sheets,multiple pages on a sheet. the layout is: column A is where the
quantity to be ordered will be entered and what I want to sort and print
by. The rows are just part numbers and descriptions and vender names.
What I would like to do is just print the rows that have a number value
in the corresponding "A" column. Printed all on the same sheet or sheets
as needed.I hope that is enough information. I used VBA to get it to
print but printed on each page and sheet resulting in some printed pages
with 1 or 2 items on them. I just can't figure how to print everything
all together. I hope that is enough information.

 

[Gord Dibben]

You cannot print non-contiguous ranges from one sheet or several sheets.

You must get the data moved to one sheet.

This would mean autofitering each sheet for a number value in column A.

Then moving the results from each sheet to a contiguous area on a new sheet.

Ron de Bruin has tips and code for this on his site.

http://www.rondebruin.nl/print.htm#non-contiguous


Gord