Automatically Generate dynamic names in Excel (with or without VBA)

Hi,

I need to find a solution to automatically generate names for specific cells in Excel.
I have absolutely NO experience at all in VBA or Macros...
I am using Office Home and Business 2013

Consider the below table as an example. (The real table is much larger so it would be impossible to create names manually for each cell)

	A	B	C	D	E	F
1	Name	Surname	Contact details	Gross revenues	Costs	Net revenues
2	Tom	Konrad	aaa	10	1	9
3	Tom	Smith	bbb	20	2	18
4	Tom	Brown	ccc	30	3	27
5	Davis	Lewis	ddd	40	4	36
6	Chris	Johnson	eee	50	5	45

I need names to be created as followed for each cell :
C2 name = "Tom Konrad Contact details"
D4 name = "Tom Brown Gross revenues"
F6 name = "Chris Johnson Net revenues"
etc.

Important : the cell reference for each name should be dynamic (i.e do not contain any $ sign) because :
the columns headers (line 1) include filters to filter and sort the numbers in each column and I need to use the names to make calculation in other tabs despite the fact that filter and sorting may change
I will for sure have new lines coming to this table and this should not affect the reference for the names.


I can't have name and surname in the same cell, they have to stay separated.

Any clue how I could to this ?

Thanks a lot for your help !!

Do you really want to name every single cell in the table?

Do you really need named ranges for the calculations?

You could use formulas to extract the values you want for the person you want.