Hi all.

I have two sheets. Sheet1 need to be filled daily. After clicking the submit button, the data from Sheet1 will be transferred to Sheet2. Sheet2 will collect the data monthly. There is a cell in Sheet1 where the user need to enter the date. The problem is, how can I copy the data from Sheet1 to Sheet2 according to their respective number of day?

*there are numbers of day (from 1 to 31) in Sheet2, column A*