I have a user form, in which user will select start and end date, it will generate reports using these dates.
A report to be generated from Sheet named "BD Raw2" using start and end date. The code should look into sheet BD Raw2 data and copy only those data which is in between start and end dates defined by user using calendar in the form to Sheet named "Report". I have written the code but it has following issues:
1) it copies data randomly and does not look into start and end date(i think)
2) data is randomly pasted in sheet "Report".( It should properly look for last blank row and paste the data there)
3) It should copy only values not formulas
Sheet is attached
Code is:
Your kind help will highly be appreciated
Bookmarks