Thread: VBA - Custom Filter

Originally Posted by royUK

I'm not sure how you would know which columns you need.

I need to be able to enter them at runtime... otherwise I'd need several versions...

For instance... one is A-J, one is A-B + K-M, one is A-B + N-O, etc. etc.

("-" means through not minus, btw.)

It would be cool if there was a way to make presets etc., but there probably isn't... so if I could just say (for example):

year = 200805
Columns = a-b, n-o
name = xrima tpl.csv

and it would generate a .csv called "xrima tpl" that had every row that had 200805 in Column A with the data from columns a, b, n, m and o.

Does that make sense?

So I could choose this stuff at run time every time...

That's what makes this all so tricky... the super-advanced bit

Thanks for soldiering on Roy... I really genuinely appreciate it.