![]() |
Printing Problem
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 |
Printing Problem
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 |
Printing Problem
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 |
Printing Problem
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 |
Printing Problem
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 |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com