Hello all,

I need to create a name range that is the total of 2 name range.

I can also create a new column with the total lists, but i want it to be flexible cuz i will insert several more items to lists. Hope you can convert this.

What i have is: in (sheet "login")
Column E Column Z
Username Username
A D
B E
C

I need to have another list called: in (sheet "Validações")
Users
A
B
C
D
E

Once in a while i increase users so i need this to be automatic in order not to forget.

Hope some one can help me