Filter Question
 

I have a sheet with a column 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

Filter Question
 

Turn on the macro recorder when you do this:

Apply the filter
filter by that helper column
Select the filtered range
edit|goto|special|check visible cells only
edit|copy

Go to the other sheet
select the cell (A1???)
edit|paste

GregR wrote:

I have a sheet with a column 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

--

Dave Peterson