Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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









  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 printing problem--printing 1 document on 2 pages Bons Excel Discussion (Misc queries) 0 December 24th 09 04:15 PM
Printing problem Dr Fumanchu Excel Discussion (Misc queries) 1 February 27th 08 01:54 PM
Printing problem gf Excel Programming 3 January 17th 05 08:45 AM
Printing Problem Roberta Excel Worksheet Functions 0 January 7th 05 05:11 PM
Printing problem Ren Excel Programming 1 October 20th 04 03:18 PM


All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"