p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_excel thread: Re: To exclude data by using Advance Filter


Message #1 by Simon Ng <smng@a...> on Tue, 03 Sep 2002 13:47:22 +0800
Alf,

Thank you so much, I appreciate your help.

Kind regards,
Simon.

alfreddearnley@n... wrote:

> >Simon:
>
> Have you tried putting in another column so that, when the new week's data
> goes in, the extra column evaluates it (=If(or(B1="RT",B1="SS"),"",B1)
> where your new data is in colB)? It seems easier to let Excel do the work
> than try to replicate its wonders in VBA!
>
> Alf
>
>  Hi ya. I have a problem maybe someone can help me.
>
> > I have a column of data that changes from week to week.
>
> > Everyweek, I need to copy the whole list to another part of the sheet.
> M> y problem starts here, I need to exclude cells that is either 'RT'
> o> r 'SS'.
>
> > I have tried advanced filter but no proper results. Can anyone help
> please.
> K> ind regards,
> S> imon.


  Return to Index