First of all in a cell enter month name and in another cell enter the employees name. In the Name Manager dialog box click the name that you want to change and then click Edit. Then in the Edit Name dialog you can reedit the Name and reselect the range scope in the Refers to section.
Click the name you want to change.
Then in the Name Manager box select the name range you want to edit from the list and click Edit button. So I want it to say Zion Branding. I want to substitute the client name in E5 for what is in Column A4 which is Zion. In the Name Manager dialog box click the name that you want to change and then click Edit.