Another Filter Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GregR - 22 Sep 2006 00:57 GMT

Sorry started this problem in another thread and didn't realize
subject was the same. I have a sheet with a column ("T) that is
conditionally filtered, with this
filter =OR($T8-$S8>25000,$T8/$S8>120%). I want to copy the cells that
meet this criteria to a new sheet. I can't quite work out the script
for the criteria. Your help is appreciated. TIA

Greg

Reply to this Message

Tom Ogilvy - 22 Sep 2006 01:42 GMT

If I understand you correctly, you already have column T filtered with a
Data=>Filter =>Autofilter where you have chosen True in the dropdown. then
On the chance that you don't know this:

Select all the data and do edit=>copy, then goto the destination and do
Edit=>paste

Only the visible rows will be pasted.

with code

Sub copyVisible()
Activsheet.Autofilter.Range.Copy Worksheets("Sheet2").Range("A1")
End Sub

Signature

Regards,
Tom Ogilvy

> Sorry started this problem in another thread and didn't realize
> subject was the same. I have a sheet with a column ("T) that is
[quoted text clipped - 4 lines]
>
> Greg

Reply to this Message

GregR - 22 Sep 2006 16:09 GMT

Tom, sorry for the confusion, no I do not have them filtered already,
they are however conditionally formatted with the criteria. What I
would like, is code to copy the rows based on the conditionally
formatted data. Somehow, I've got to apply the conditionally formatted
criteria to a filtered criteria. TIA

Greg

> If I understand you correctly, you already have column T filtered with a
> Data=>Filter =>Autofilter where you have chosen True in the dropdown. then
[quoted text clipped - 23 lines]
> >
> > Greg

Reply to this Message

Tom Ogilvy - 22 Sep 2006 17:55 GMT

Guess you threw me off when you said

> column ("T) that is
> conditionally filtered, with this

You just need to use the same condition to filter your data.

Dave gave you the instructions - however it appears he assumed that column T
is a dummy column. I believe based on your latest that you will have to
create a dummy column with your conditional formatting formula. Then apply
the filter to that column.

Signature

Regards,
Tom Ogilvy

--
Regards,
Tom Ogilvy

> Tom, sorry for the confusion, no I do not have them filtered already,
> they are however conditionally formatted with the criteria. What I
[quoted text clipped - 30 lines]
> > >
> > > Greg

Reply to this Message

GregR - 22 Sep 2006 18:09 GMT

Tom, appreciate the answer that I was afraid of. Thanks again

Greg

> Guess you threw me off when you said
>
[quoted text clipped - 50 lines]
> > > >
> > > > Greg

Reply to this Message

Dave Peterson - 22 Sep 2006 20:15 GMT

You're right.

I read "conditional filtered" as using data|filter|autofilter, not conditional
formatting.

> Guess you threw me off when you said
>
[quoted text clipped - 50 lines]
> > > >
> > > > Greg

Signature

Dave Peterson

Reply to this Message

GregR - 22 Sep 2006 22:24 GMT

Dave, as I learn from you and Tom, maybe you could throw in some
english lessons as well. TIA

Greg

> You're right.
>
[quoted text clipped - 55 lines]
> > > > >
> > > > > Greg

Reply to this Message

Dave Peterson - 22 Sep 2006 23:08 GMT

I don't think it would help. I read what I want--not what the user wrote.

(And I read a message that I posted earlier today and saw about 3 grammatical
errors in the first sentence. But now, I just shake my head and sigh--instead
of posting an "English" version of what I meant! <vbg>)

> Dave, as I learn from you and Tom, maybe you could throw in some
> english lessons as well. TIA
[quoted text clipped - 63 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message