RE: Excel ? -- PCTECH

Thanks its gonna be lotta manual effort (5K rows total) but looks like only
way)

Mark Allen
IS Manager
Wilkes Telephone & Electric
11 W. Court Street
Washington, GA 30673
Phone: (706) 678-9565
Cell: (706) 498-7907
Fax: (706) 678-1000


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of David A Parnin
Sent: Wednesday, May 12, 2004 5:01 PM
To: pctech@xxxxxxxxxxxx
Subject: RE: [PCTECH] Excel ?



You should be able to hide the rows/columns that you don't want, set your
print area, and only get what you see.

Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx




 

                      Mark Allen

                      <mallen@xxxxxxxx>        To:       PC Technical
Discussion for iSeries Users            
 
<pctech@xxxxxxxxxxxx>@SMTP@CTB                                
                      05/12/2004 03:34         cc:

                      PM                       Subject:  RE: [PCTECH] Excel
?                                 
                      Please respond to

                      PC Technical

                      Discussion for

                      iSeries Users

                      <pctech@midrange.

                      com>

 

 




Problem is they are intermixed, may have 4 rows in a row not red, the 2 red
then 3 not then 4 red

Mark Allen
IS Manager
Wilkes Telephone & Electric
11 W. Court Street
Washington, GA 30673
Phone: (706) 678-9565
Cell: (706) 498-7907
Fax: (706) 678-1000


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of rware@xxxxxxxxxxxxxxxx
Sent: Wednesday, May 12, 2004 4:27 PM
To: pctech@xxxxxxxxxxxx
Subject: RE: [PCTECH] Excel ?


If you have rows that aren't together I don't think the selecting the range
thing is going to work.  I am sure it would be possible though with a macro
with some vba.

> -----Original Message-----
> From:     Mark Allen [SMTP:mallen@xxxxxxxx]
> Sent:     Wednesday, May 12, 2004 3:10 PM
> To: pctech@xxxxxxxxxxxx
> Subject:  [PCTECH] Excel ?
>
> I have a spreadsheet that has certain ones where one of more of 3 
> columns is in red.  Is there any way to just print those rows
>
> Mark Allen
> IS Manager
> Wilkes Telephone & Electric
> 11 W. Court Street
> Washington, GA 30673
> Phone: (706) 678-9565
> Cell: (706) 498-7907
> Fax: (706) 678-1000
>
> _______________________________________________
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list To post a message email: PcTech@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at 
> http://archive.midrange.com/pctech.
_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.

_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.




_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.