Filter Question

  • Thread starter Thread starter GregR
  • Start date Start date
G

GregR

I have a sheet with a column 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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Filter Question 7
Macro to compare and copy ranges of cells 4
Split cell contents and sum numbers 3
Samsung Galaxy S8 review round up 3
I want to create a Summary Work Sheet... 2
Code Does Not Work 21
numbers, text 1
IF - Nesting... almost got it - need a bit of help 1

Back
Top