I have this example data...
A. B. C.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
What i need is a macro that can find all of a particular location (name) from column c then return the date in a message box. from a certain time frame. Example would be the user would want to look up west central from 6/7-6/9 and return the dates that data was entered into this database in a message box. So this query's result would be 6/7
6/9
which represents that 6/8 was not recorded. If the macro could then message box the user that 6/8 was missing that would be helpful but not necessary
I may also in the future want it to return other column's data
The user will access this by clicking a button then will be prompted to put in the date range and club name. Then the results will be presented.
The data they are accessing is in another workbook
A. B. C.
Topeka SE-6/9/2015 | 6/9/2015 | Topeka SE |
Man Spa-6/9/2015 | 6/9/2015 | Man Spa |
Manhattan West-6/9/2015 | 6/9/2015 | Manhattan West |
Mcpherson-6/9/2015 | 6/9/2015 | Mcpherson |
Emporia-6/9/2015 | 6/9/2015 | Emporia |
Topeka North-6/9/2015 | 6/9/2015 | Topeka North |
South Lawrence-6/9/2015 | 6/9/2015 | South Lawrence |
Manhattan East-6/9/2015 | 6/9/2015 | Manhattan East |
Leavenworth-6/9/2015 | 6/9/2015 | Leavenworth |
West Central-6/7/2015 | 6/7/2015 | West Central |
St. Joe-6/9/2015 | 6/9/2015 | St. Joe |
West Central-6/9/2015 | 6/9/2015 | West Central |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
What i need is a macro that can find all of a particular location (name) from column c then return the date in a message box. from a certain time frame. Example would be the user would want to look up west central from 6/7-6/9 and return the dates that data was entered into this database in a message box. So this query's result would be 6/7
6/9
which represents that 6/8 was not recorded. If the macro could then message box the user that 6/8 was missing that would be helpful but not necessary
I may also in the future want it to return other column's data
The user will access this by clicking a button then will be prompted to put in the date range and club name. Then the results will be presented.
The data they are accessing is in another workbook