Thread: Universal name for formulas in sheets

Hello! I'd like to create an "universal name" for a certain formula, that it might be applied to different sheets. I mean, whenever you define a name, it somehow gets attached to the sheet name. I wanted to have some sort of "dynamic name", so the formula it may also be applied to every single sheet.

PS. I've attached a quite slobby example of what I'm trying to obtain, just to give an idea of how it's supposed to work. I really hope that someone can figure it out, cause I really couldn't find anything related to such thing on the internet... Thanks in advance!

Define a name with workbook scope

Master Refers to: =MASTER!$A$5:$G$5

On each client sheet, define a name with sheet scope:

'CLIENT 01'!Client Refers to: ='CLIENT 01'!$A$5:$G$5

(If you do this once on a client sheet, and then copy the sheet, you'll have a new name with sheet scope on each copy.)

Then in each client sheet, the total is

=SUMPRODUCT(Master * Client)

What do you know.. It worked perfectly!!


Thank you very much for your help shg!!

You're welcome, glad it worked for you.