In cell A2 I have it set up as Name. I would like cell E2 to reflect the same entry automatically (I put in cell E2 =A2). =A2 works but when cell A2 is blank there is a '0' in E2. Can anyone assist in correcting this as I would like cell E2 to be blank until cell A2 is filled with data. Attached is the example.
Thank you in advance.