by Paul Kelly | | Copying Data, Databases, Vault Video
Webinar Number: W0058 This webinar includes: Why querying data using standard VBA is problematic. What is ADO and how can I use it. How to easily set up ADO using VBA code. How to use SQL to perform a simple query. How to write the query results to a worksheet....
by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0050 This webinar features: Live Excel VBA Coding A simple guide that will help you select the correct worksheet every time How to decide which workbook should contain the code How to copy data on the same worksheet How to copy to or from a closed...
by Paul Kelly | Sep 25, 2021 | Copying Data
VBA Advanced Filter is one of the many hidden gems that Excel VBA offers to make our time more productive. VBA Advanced Filter requires very little code, is one of the fastest ways to copy data, and provides advanced filtering options that we cannot get anywhere else....
by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0043 Back in May I ran a webinar on Advanced Filter and it was extremely popular. Advanced Filter is one of the best ways to copy and filter data using VBA. However, most people don’t know about it and end up using for Loops or some other...
by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0040 If you have been using Excel VBA for a while you’ve known that there are many ways to copy and filter data. You can use a For loop, Range.Copy, Autofilter, WorksheetFunction.Index and so on. One day, I thought to myself – which one of...
by Paul Kelly | | Copying Data, Most Popular, Vault Video
Webinar Number: W0027 This webinar features: Live coding Why you shouldn’t use a For Loop How to use Advanced filter correctly The common mistakes to avoid when using Advanced Filter A sample application using Advanced Filter functionality Proven principles used...
