I have successfully created a form that populates to my xlsm on sharepoint. I need to find a way to either copy rows to different sheets based on the date or to have it populate automatically to different sheets. We are using this so multiple people can add assignments to the workbook but I need them automatically copied to the specific dated sheets. We use this daily so it will be ongoing and once the dates are passed, we will delete those dates sheets manually.
