Search results

Limit Filter To my knowledge there is know filter within excel. I have used the autofitler with 30,000 records. Can you be more specific?

= COUNTIF(C1:C65000,"yes") Just chaned the C to whatever column you are refering to.

I'm able to get external data for simply queries like select rtrim(app.sys_channel_cd), rtrim(app.mrkt_source_cd), rtrim(app.opr_application_nr), rtrim(apt.APPLICANT_NM), act.activity_dt from heids.dly_activity act join heids.dly_application app on act.application_id = app.application_id join...

I know how to link the tables in the ODBC to access. However, how do I bypass putting my password into everytime I run a query? VBA? If you know how to do it with VBA please provide feedback.