ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing Problem (https://www.excelbanter.com/excel-programming/353052-printing-problem.html)

Mickey Mouse[_5_]

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




Ron de Bruin

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






Mickey Mouse[_5_]

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








Ron de Bruin

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










Mickey Mouse[_5_]

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