Initials name return a full name in the same cell

[Elliot]

Is there a way to put a initials name as ie. A1=JD and A1 return A1=John Doe + today() and green color?
pic example attached
thanks for your help

 

[ThrottleWorks]

Hi @Elliot , can we use a mapping file with both the names present i.e. short name and full name. Then take a vLookUp and intergrate =today() formula in the vLookUp.

Also, there is a feature in excel which will replace the string as you type but I guess that will be risky.

Excel Options Alt T O
Proofing
Auto Correct Options.

 

[Hui]

or use VBA and Change Event to rearrange the info

 

[Elliot]

or use VBA and Change Event to rearrange the info

So how would it be?

 

[Elliot]

Hi @Elliot , can we use a mapping file with both the names present i.e. short name and full name. Then take a vLookUp and intergrate =today() formula in the vLookUp.

Also, there is a feature in excel which will replace the string as you type but I guess that will be risky.

Excel Options Alt T O
Proofing
Auto Correct Options.

So how would it be?

 

[ThrottleWorks]

Hi @Elliot , please give me some time, I will try to explain in detail.

 

[chirayu]

check this

 

[chirayu]

forgot to attach file. tell me if it works

 

[Elliot]

check this

Thanks for your help , but if i want in any cell of my worksheet and the color??

 

[chirayu]

try this

 

[Elliot]

thanks for your help

 

[chirayu]

I figured out why the sheet name changed. Because the variable I used was same as the inbuilt Excel Variable so changed Name to MyName. But unsure why its not colouring your other cells because I downloaded the file & tested it again and seems to be colouring for me

 

[Elliot]

thanks for your help

 

[chirayu]

If Initials are in A & Names are in B then change the "K:L" to "A:B"

 

[Elliot]

If Initials are in A & Names are in B then change the "K:L" to "A:B"

but in other sheet --> sheet2 ie

 

[chirayu]

Then code would change to Worksheets("Sheet2").Range("A:B")

 

[Elliot]

Many thanks for your help