Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing inventory
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing inventory
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 "Richard" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing inventory
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 On Wed, 21 May 2008 12:57:30 -0400, Richard wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing inventory
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. Thanks Richard wrote: 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing inventory
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 On Thu, 22 May 2008 09:54:05 -0400, Richard wrote: 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. Thanks Richard wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory | Excel Worksheet Functions | |||
Inventory Age | Excel Worksheet Functions | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
bar inventory | Excel Worksheet Functions | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |