Hi,

I have some code that produces a name in one cell when a number is put in another cell, this works great. (i got the code from here https://www.excelforum.com/excel-pro...signature.html)

I am now trying to put the date in an adjacent cell when the name appears using =IF(C1="Name",Today(),"")
When I do this the code stops working

I know very little (nothing) about code so any help appreciated!

Thanks

Kevin