Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I Have a list of parts 340 lines(rows). I need to print ONLY the items on order. I need to print the whole line from A to E. Is this possible? Way beyond me. A B C D E 1 Part # Desc. Color Size Ord Qty 2 Nails 3 4 00032 3/4" Plain Brass 12 5 00021 1/2" Plain Bronze 6 6 00008 3" Twist Plain 7 00054 4" Twist Plain 25 8 9 10 Screws 11 12 00033 1/2" Wood Zinc 100 13 00043 1/2" Metal Brass 14 00028 3/4" Metal Zinc 100 : : : 340 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Mickey
You can filter on the order column and print In your example I not see data in the Order column ? See http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message ... I Have a list of parts 340 lines(rows). I need to print ONLY the items on order. I need to print the whole line from A to E. Is this possible? Way beyond me. A B C D E 1 Part # Desc. Color Size Ord Qty 2 Nails 3 4 00032 3/4" Plain Brass 12 5 00021 1/2" Plain Bronze 6 6 00008 3" Twist Plain 7 00054 4" Twist Plain 25 8 9 10 Screws 11 12 00033 1/2" Wood Zinc 100 13 00043 1/2" Metal Brass 14 00028 3/4" Metal Zinc 100 : : : 340 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
But if there was an order, then I'd like to print that whole line.
Mickey "Ron de Bruin" wrote in message ... Hi Mickey You can filter on the order column and print In your example I not see data in the Order column ? See http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message ... I Have a list of parts 340 lines(rows). I need to print ONLY the items on order. I need to print the whole line from A to E. Is this possible? Way beyond me. A B C D E 1 Part # Desc. Color Size Ord Qty 2 Nails 3 4 00032 3/4" Plain Brass 12 5 00021 1/2" Plain Bronze 6 6 00008 3" Twist Plain 7 00054 4" Twist Plain 25 8 9 10 Screws 11 12 00033 1/2" Wood Zinc 100 13 00043 1/2" Metal Brass 14 00028 3/4" Metal Zinc 100 : : : 340 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Filter on the Ord Qty column for example 0 It will hide all rows with no Ord Qty then Now print the sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message u... But if there was an order, then I'd like to print that whole line. Mickey "Ron de Bruin" wrote in message ... Hi Mickey You can filter on the order column and print In your example I not see data in the Order column ? See http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message ... I Have a list of parts 340 lines(rows). I need to print ONLY the items on order. I need to print the whole line from A to E. Is this possible? Way beyond me. A B C D E 1 Part # Desc. Color Size Ord Qty 2 Nails 3 4 00032 3/4" Plain Brass 12 5 00021 1/2" Plain Bronze 6 6 00008 3" Twist Plain 7 00054 4" Twist Plain 25 8 9 10 Screws 11 12 00033 1/2" Wood Zinc 100 13 00043 1/2" Metal Brass 14 00028 3/4" Metal Zinc 100 : : : 340 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks
"Ron de Bruin" wrote in message ... Hi Filter on the Ord Qty column for example 0 It will hide all rows with no Ord Qty then Now print the sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message u... But if there was an order, then I'd like to print that whole line. Mickey "Ron de Bruin" wrote in message ... Hi Mickey You can filter on the order column and print In your example I not see data in the Order column ? See http://www.rondebruin.nl/print.htm#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "Mickey Mouse" wrote in message ... I Have a list of parts 340 lines(rows). I need to print ONLY the items on order. I need to print the whole line from A to E. Is this possible? Way beyond me. A B C D E 1 Part # Desc. Color Size Ord Qty 2 Nails 3 4 00032 3/4" Plain Brass 12 5 00021 1/2" Plain Bronze 6 6 00008 3" Twist Plain 7 00054 4" Twist Plain 25 8 9 10 Screws 11 12 00033 1/2" Wood Zinc 100 13 00043 1/2" Metal Brass 14 00028 3/4" Metal Zinc 100 : : : 340 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Printing problem | Excel Discussion (Misc queries) | |||
Printing problem | Excel Programming | |||
Printing Problem | Excel Worksheet Functions | |||
Printing problem | Excel Programming |