Hi Everyone!
I don't know much about VBA. I created a user form for my library with the help of many articles and YouTube videos. I have created this form for maintaining record of daily issue books. Books are of 6 categories "NCB", "CPB", "MEB", "DCB", "PMB", "PSB". I want everyday when I open user form it create a new sheet automatically and save previous data into that new sheet and clear the sheet from where the data has been copied. And I also want to add a date range for finding previous data. I mean if I select two dates I can see total issued books on these date in user form and can export to another excel sheet.
Please help me in this project.
Thanks
I don't know much about VBA. I created a user form for my library with the help of many articles and YouTube videos. I have created this form for maintaining record of daily issue books. Books are of 6 categories "NCB", "CPB", "MEB", "DCB", "PMB", "PSB". I want everyday when I open user form it create a new sheet automatically and save previous data into that new sheet and clear the sheet from where the data has been copied. And I also want to add a date range for finding previous data. I mean if I select two dates I can see total issued books on these date in user form and can export to another excel sheet.
Please help me in this project.
Thanks