Thank you so much, I appreciate your help.
> 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!
> 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
> K> ind regards,
> S> imon.