Call in the Cavalry - 2019

OP does not want to manually insert formulas so I believe this requires VBA:

https://www.excelforum.com/excel-gen...ple-sheet.html

Edit: It doesn't sound like they want a VBA solution either. Not sure any solution will be approved by them but I'll leave this here anyway.

Originally Posted by 63falcondude

OP does not want to manually insert formulas so I believe this requires VBA:

https://www.excelforum.com/excel-gen...ple-sheet.html

Edit: It doesn't sound like they want a VBA solution either. Not sure any solution will be approved by them but I'll leave this here anyway.

Could you suggest grouping the sheets, then entering the formula in the grouped sheets?