| T O P I C R E V I E W |
| Fiogter |
Posted - 05/24/2018 : 07:41:29 AM
Hi there,
I´d like to apply the same filter to about 100 columns.
How do i do that? (besides of clicking every single column and applying it)
Best regards
|
| 1 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 05/24/2018 : 11:27:47 AM
Hello, suppose you have filter set in column 1 already and what to apply to all other columns from 2nd column on, you can run the following script.
for (ii=2; ii<=wks.ncols;ii++)
{
wks.col$(ii).filter=1; //turn on filter
wks.col$(ii).filter$=wks.col1.filter$; //copy col1's filter condition
}
wks.runfilter(); //execute all filters
Thanks, Snow |
|
|
