VBA to enter a date, to list the date, some data of the highest five company name-CodePudding

Home > Software engineering > VBA to enter a date, to list the date, some data of the highest five company name

VBA to enter a date, to list the date, some data of the highest five company name

Time：09-25

What function can use to tackle this problem?? I can go to check, the best example is given thanks!

CodePudding user response:

Autofilter
Apparently filtering, you can see AutoFilter method

CodePudding user response:

Using the database, is the most common query

 SELECT TOP 5 * 
FROM the data table 
WHERE the date date=@ 
Data ORDER BY DESC

CodePudding user response:

AdvancedFilter