Report

Auto populate text and add total from one sheet to another

Hello,

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):
Name Toileted
BOB 1
Amy 0

EXAMPLE (Sheet 2 for August):
Name Toileted
BOB 2
Amy 1
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!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!