Tom and Richard... On the Right Track (Excel Query)
Posted by Brett Holcomb on October 24, 2001 4:41 PM
Tom and Richard,
You guys almost have me where i need it. I am, however trying to do this many times thus automated with VBA.
Here is what I have... A database (in Access) with a huge list of times. I like to print out various reports, some of them with the top 25 from all years, some the top 25 from this year, some the top 10 this year, etc. Instead of going to each Excel page and updating them manually (determining where the top times would fit in, etc), I would like to pull the data from the database and then specify in Excel what kind I am looking for (a top 25 list, a top 10 list, etc). Then, when I enter faster times from the next meet into the database and refresh my queries, it will automatically update with any new top times in the right sheet (top 25 sheet, top 10 sheet, etc). I don't know if this makes sense... I really really appreciate your help.