Changing Values of one cell based on the Other in Excel
<p>I am new to Excel and VBA. I am making a Project list wherein I have two columns for Status, <code>Status</code> and <code>Status in Words</code>. In the former I Need to enter the Status in form of numbers, e.g. 50% or 80% and in the latter I Need to enter the Project Status in words i.e. Open, Closed, In Progress etc. My Problem is that when I write 50 % in the first column, the Status in the other column should automatically Change to <code>In Progress</code> and vice versa if I type <code>Closed</code> in the second column, then the Status in the first column should Change to <code>100%</code>. Could anyone tell me how to procede with this in Excel vba.</p>