Create sheet based on input and copy data from master to new sheet

[radhy19]

Good afternoon,

I have a userform that has a datepicker and I want to be able to when I hit submit it creates a new worksheet based on the month in the date and copy the row from the master journal to the corresponding month sheet.
any help you can provide will be greatly appreciated.

 

[My Aswer Is This]

So you want to create a new sheet and name it the value in the Combobox you select.
What is the name of this combobox?
So give me a example of what you might select.
Is it like 4/24/2022
And how would you want the new sheet named in this example?
Would it be Like "April"
And then you said:
and copy the row from the master journal to the corresponding month sheet.
Is master journal a sheet name "Master Journal" and copy what row?
Specific details like this are always Important

 

[radhy19]

Good morning, thank you for answering to my post.
Yes, I'm looking for it to create a new sheet if I choose a date for the month of June then it would crate that sheet for the month of June. And after it creates it all the input from there on that belong to the month of June would be copied to that sheet. The name for the sheet would be month and year "April 2022".
Yes, I have a master Journal "LSJ" that all the data will accumulated in so I can run reports from.
I have uploaded a picture of the calendar and one of the form that contains the way that the date is displayed