Thread: Printing Problem- Is this possible?

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

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" <MickeyMouse@DisneyLand.com> wrote in message news:43ede37d$0$9138$afc38c87@news.optusnet.com.au...
>
> 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
>
>
>

But if there was an order, then I'd like to print that whole line.

Mickey

"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:uL2wW3wLGHA.1088@tk2msftngp13.phx.gbl...
> 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" <MickeyMouse@DisneyLand.com> wrote in message
> news:43ede37d$0$9138$afc38c87@news.optusnet.com.au...
>>
>> 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
>>
>>
>>
>
>

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" <MickeyMouse@DisneyLand.com> wrote in message news:43edf2f9$0$15125$afc38c87@news.optusnet.com.au...
> But if there was an order, then I'd like to print that whole line.
>
> Mickey
>
> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:uL2wW3wLGHA.1088@tk2msftngp13.phx.gbl...
>> 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" <MickeyMouse@DisneyLand.com> wrote in message news:43ede37d$0$9138$afc38c87@news.optusnet.com.au...
>>>
>>> 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
>>>
>>>
>>>
>>
>>
>
>

Thanks



"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:ukebNsxLGHA.2828@TK2MSFTNGP12.phx.gbl...
> 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" <MickeyMouse@DisneyLand.com> wrote in message
> news:43edf2f9$0$15125$afc38c87@news.optusnet.com.au...
>> But if there was an order, then I'd like to print that whole line.
>>
>> Mickey
>>
>> "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
>> news:uL2wW3wLGHA.1088@tk2msftngp13.phx.gbl...
>>> 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" <MickeyMouse@DisneyLand.com> wrote in message
>>> news:43ede37d$0$9138$afc38c87@news.optusnet.com.au...
>>>>
>>>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>