Determining active sheet without vba

2018-10-14 08:55:47

I am using OfficeSuite android app for excel spreedsheets. Vba not available. Have multiple sheets (12+) that use a common sheet for complex & common calcs. I Index in the common by last or curr date on each. But if 2 or more sheets have curr or same date I would like to have the common sheet know the active sheet. A workaround was to duplicate all calc in the common for a second psudo (differant index) sheet.