I am trying to work on a yearly spreadsheet that has tabs for each month.
What we are trying to do is each month we update monthly tabs with names and no. of times person toileted and have another sheet auto populate the names and counts the totals of being toileted within 6 months.
EXAMPLE (Sheet 1 for July):
EXAMPLE (Sheet 2 for August):
In next months Bob and Amy were not toileted.
For Sheet that auto populates must update itself with BOB 3 and Amy 1 (total of Toileted added from past 6 months)
Will appreciate the help a lot!
Auto populate text and add total from one sheet to another