- Nov 9, 2020
- Office Version
I need to generate a report each month based on activities offered on a given date, persons participating in the activities, and staff attending with the person. Some staff may be attending with multiple persons and I do not want to count them more than once. There may be multiple activities offered on each day, but I do not know how to get the dates of the activities and the activities to go from my spreadsheet to my report, without inputting the data manually. Additionally, I need to count how many persons participated in each activity and how many staff attended with the persons (again, only counting the staff once for each activity). I have looked through threads and the internet and I cannot figure out how to do this without manually putting in several rows with the dates (e.g., 06/10/21 over three rows) and then manually inputting the data. Any assistance would be most appreciated.