• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA CODE BASED ON CALENDER DATE SELECTION

Hi,

I'm not sure I understood the requirement, but if you wanted a "Date Picker" to input the dates and formulas to count the matches in "master" sheet, then please refer to the attached file.

Simply select on of the highlighted cells and you will be prompted to select a date.

Let me know if I understood correctly and if it is working as intended.

Adapted from: http://trevoreyre.com/portfolio/excel-datepicker/
All credit to him!
 

Attachments

Last edited:
Back
Top