Aug 01 2020 04:22 AM
Aug 01 2020 04:31 AM
Aug 01 2020 05:08 AM
Aug 01 2020 07:45 AM
Aug 01 2020 10:30 PM
@Adhi_1 Consider gathering all attendance records for all names in one single sheet. Create a pivot table, as shown in the summary sheet in the attached example. If you insist on having 60+ sheets, you can then select the pivot table option "Show Report Filter Pages..." and then confirm to use "Sheetname". This will create eparate pivot tables for each sheet name. I've done that for five sheets in my example. Change a number in the summary, press "Refresh all" on the Data ribbon and all tables will be updated.
Perhaps you realise that you actually don't need 60 different sheets, as you can easily create an overview for the sheet you are interested in from the overall pivot table. Up to you, though.