RE: [PCTECH] Excel ?

[Mark Allen <mallen@xxxxxxxx>]

Col A      Col B         Col C
XYZ        XYZA          Formula if a=b then 0 else 1

Then turn on auto filter in C and select only those values=1
Cut and paste to another sheet and print 

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: Thursday, May 13, 2004 2:05 PM
To: pctech@xxxxxxxxxxxx
Subject: RE: [PCTECH] Excel ?


Don't keep it a secret.

> -----Original Message-----
> From: Mark Allen [SMTP:mallen@xxxxxxxx]
> Sent: Thursday, May 13, 2004 12:58 PM
> To:   'PC Technical Discussion for iSeries Users'
> Subject:      RE: [PCTECH] Excel ?
> 
> Thanks all I found a workaround
> 
> 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 Joe Giusto
> Sent: Thursday, May 13, 2004 1:34 PM
> To: PC Technical Discussion for iSeries Users
> Subject: RE: [PCTECH] Excel ?
> 
> 
> How about control click on the second column after clicking on the 
> first column that you want selected?
> 
>  -----Original Message-----
> From:         rware@xxxxxxxxxxxxxxxx [mailto: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.