Excel VBA filter search

Please kindly assist me with error am getting and I have attached a copy.

I want to filter by sheet name and year to the monthly summary.

And also want to prevent duplicate year and month when saving data on the user form.

Thank you

hello,

I want to filter by sheet name and year to the monthly summary.

select the sheet via the drop-downlist linked to the field insurance name.

And also want to prevent duplicate year and month when saving data on the user form.

Can you explain this with more details ? Give the steps (with data) to reproduce the issue, show the issue and document the expected result for the given data.

Thank you for the responds.When i select the sheet name and the year then click the filter buttonit gives me error code 1004 and hihlight as attached

The second issues is after saving data, when you search by year and month then edit the data and you forget to click the update button and clik the save button again it will save as new, but if it can prevent duplicate by year and month. I hope my explaination is clear.

Thank you

Dear,

To solve your problems, I would completely redesign and rework your application, but that's not the kind of application I want to spend time on.

I understand you. Thank you