According to different multi-worksheets, the TOTAL table records the changed data of each

According to different multi-worksheets, the TOTAL table records the changed data of each worksheet B1

Multiple worksheets, the data of each cell B1 changes automatically to add the name of the worksheet corresponding to TOTAL down

For example

A1 worksheet B1 cell just started to enter 786, so automatically fill in 786 in the TOTAL worksheet B2
Then enter 238 in cell B1 of worksheet A1, so 238 is automatically filled in in worksheet B3 of TOTAL
And so on

Any help is greatly appreciated

Please Login or Register  to view this content.