Copy data into filtered row

This has been bugging me for quite sometime now and despite searching everywhere, i am not able to make it work.

See attached file, data is input in the Main tab from D5 to M5. Also, the type of fruit sold is selected from the dropdown in B5 and the day of the month is given in A5. Based on the 2 parameters in A5 and B5, i would like to filter in Sheet 1. Once filtered, i would like to copy the data from D5 to M5 into the filtered row from columns C to L.

I have tried this code:

Please Login or Register  to view this content.

But it does not seem to work. No data is getting pasted into Sheet1.

Please help. Appreciate all the help with this.

Something like this?

Please Login or Register  to view this content.

Thanks Jiejenn.

Worked just as i needed.