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


--
Regards,
Tom Ogilvy


"GregR" wrote in message
oups.com...
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-$S825000,$T8/$S8120%). 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