When the cell is filled with value, automatically update the value in other cell

[hai_krk]

Hi,

I am filling in C8 based on which the J8 should set the default value as "NOt done". I hvae done this using formula in cell J8 but it goes of if we delete it.

This should be repeated till row no 100.
for example if i fill c100 then similarly J100 should be not done

How to write macro for this.

[JBeaucaire]

Something like this, replace the "100" with whatever your criteria is:

Please Login or Register  to view this content.

This goes into the sheet module.

[shg]

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

The problem does not depend on the specific cells involved, and only serves to make the thread title useless for anyone searching for help on a similar problem.

[hai_krk]

Hi ,

thanks for reply.

It works other way around. May be my mail was no clear

Only after filling cell c8 then J8 should set as "Not done".

but in the code even if cell c8 is blank it shows J8"Not done"

please help me out in solving this

[DonkeyOte]

hai_krk, you have been requested to alter your thread title by a Mod and have not done so and until such time as you do I'm afraid no responses to your question are permitted.

[martindwilson]

try

Please Login or Register  to view this content.