Macro to create defined names

[Cammandk]

I want to have a macro that will create defined names from a list
As the list is added to it needs to run again and not create old names again or create an error message and just add the names that don't yet exist.

COL A COL B
Job1 defined name in Col B - name needs to be "GL" & Job1 & "Rate"
Job2 defined name in Col B - name needs to be "GL & Job2 & "Rate"


ColA may be added to needs to be dynamic?

Thanks
DK

 

[NARAYANK991]

Hi David ,

Please upload a sample workbook.

Narayan

 

[Cammandk]

Hi Nara
Hope this is clear
David

 

[NARAYANK991]

Hi David ,

See if this is OK.

Narayan