How to extract month-specific data from a master list into separate sheets?

Hello there!

I am SUPER new to Excel and am in need of some assistance. I'm in the insurance industry and have created a call log for myself and the office. It is a basic log using VBA and UserForms for data entry. I'll upload a demo copy of what I've done so far to this post.

As of right now, all data that is entered goes straight into the a Sheet titled, "Tracking Log." I've input a small amount of sample data using popular movie figures to show what my current product looks like. What I'm trying to figure out how to do is either one of the two below:

1. Have the data entered into the userform get sent directly to it's corresponding date sheet (i.e. if 05/10/2018 is entered into the "Date" box in the userform, then that entry goes into the sheet titled, "May."

OR

2. Have each month-titled-sheet extract data from the main Tracking Log sheet in order to display month-specific information.




Hopefully this makes sense. I've spent tons of time perusing about the internet trying to find a way to make this happen, but have been unsuccessful so far. Like I started with, I'm extremely new to Excel and VBA/Userforms/Etc. If anybody has any suggestions on how to make this happen, it would be most appreciated!


Many thanks,


Ben

Any thoughts from the forum?

JLGWhiz,

Thank you for your response! I'm currently having a palm-to-forehead moment for this reason:

Something I just realized/remembered that might be crucial would be that there is a difference between the two projects referenced above (why it took this long for me to mention, I'm not sure). In my actual, currently-being-used-daily call log, I have a second userform/macro that I'm building into the project for a secondary call log within the main one (hopefully this doesn't get too confusing). Both macros have a text box for the date, thus using the Me.txtDate.Value in the code. The Demo project I attached to my original post didn't contain this extra macro/userform.

Could it be that the code you supplied is getting confused between the two macros with identically named components in the project and therefore returning the aforementioned error? This would then clarify why your code worked perfectly in the Demo project I supplied in my original post because that project does not contain the second macro/userform.

Let me know what you think. As always, I greatly appreciate your help with this!!!


Many thanks,



Ben

Any thoughts from the forum?


Thanks,


Ben