Automatically change cell value based on other cell value

Re: Automatically change cell value based on other cell value

Hi etheer. You already have the code that I used in a previous attachment. It is the code you included in your last post. You cannot use this code as a Worksheet_Change event as well as the formulas I included in my last attachment. You have to use either the code or the formulas ...YOU CANNOT USE BOTH. They both do exactly the same thing. You have to choose one method only. Why do you need the code if the formulas work well and do what you wanted?

Re: Automatically change cell value based on other cell value

etheer,

In post #10 I showed you how to use code tags and emphasized they are *REQUIRED* when posting VBA code.
In post #20, you omit the code tags, again.

Please edit your post (#20) to add the missing code tags.
If you continue to post code without using the tags, your thread will be locked until you have read and agree to abide by the forum rules.

Re: Automatically change cell value based on other cell value

Hello etheeer. I really want to help you but I am confused by what you are trying to do. The code will not work properly when you use it with the formulas. If you use the formulas only, you do not have to type "Yes" or "No" in column J. The formula in that column will enter "Yes" or "No" automatically based on the contents of columns G and F. When you use only the Worksheet_Change event code, you have to type "Yes" or "No" in column J. If you try to use both the formulas and the code, when you type the word "Yes" or "No" in column J, it will replace the formula and the formula will be deleted. This is why you have to choose one method only. I still don't understand why you need both the code and the formulas together when you need only one method to do what you want. *****Please read and follow AAE's instructions on how to properly post your code or your post will be locked.

Re: Automatically change cell value based on other cell value

Try the revised attached file.

Re: Automatically change cell value based on other cell value

Change the "No" to "Yes" and then change to "No" again. This problem is created when you try to use both the code and the formulas.

Re: Automatically change cell value based on other cell value

Hi etheer,
please try with the attached file, hope it will serve your purpose.

Re: Automatically change cell value based on other cell value

I'm having trouble downloading your file. Send it as an attachment in your post. Click 'Go Advanced' and use the attachment icon to attach your file.

Re: Automatically change cell value based on other cell value

In the formulas in column J you use the values in columns M, N, O, P, F, X and Y. If you look at rows 45, 75 and 142, you will see #DIV/0! . All the cells in columns M, N, O, P, F, X and Y must have a value. They cannot be blank or have a value of 0. Enter some values in these cells (not in column J) and the error should disappear.

Re: Automatically change cell value based on other cell value

Sheet M2 does not have any code. The code for the Worksheet_Change event is attached to Sheet M1.