What if you want to use "Dave" instead of "Natalie"?
In your code you paste values in L6, but the macro does not show what has been copied so that it can be pasted. Please clarify.