W webmax Member Jun 18, 2014 #1 Hi I have a Emp code in the Data B2 Cell if i change the Emp Code automatically B3 Cell need to be blank. The B3 Cell i will keep manually. I am attaching the file for your reference. Attachments cellchange.xlsx cellchange.xlsx 8.7 KB · Views: 4
Hi I have a Emp code in the Data B2 Cell if i change the Emp Code automatically B3 Cell need to be blank. The B3 Cell i will keep manually. I am attaching the file for your reference.
chirayu Well-Known Member Jun 18, 2014 #2 You'll need to add a macro that empties the cell on cell change You'll need to add a Worksheet Change event and use the ClearContents code
You'll need to add a macro that empties the cell on cell change You'll need to add a Worksheet Change event and use the ClearContents code
N NARAYANK991 Excel Ninja Jun 18, 2014 #3 Hi Shahul , See this file. Narayan Attachments cellchange.xlsm cellchange.xlsm 13.1 KB · Views: 5
