Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter question | Excel Discussion (Misc queries) | |||
Another Filter Question | Excel Discussion (Misc queries) | |||
Filter question | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
a filter question | Excel Discussion (Misc queries) |