Run VBA when any cell within range <>=""

[p4nny]

Hi

Basically, I'm trying to run code when a value is entered in range("A:A"). The code will repopulate specific cells with formulae if the user inserts a new row and enters a value into Range("A:A")

I've searched for an event for INSERT ROW but this has been unsuccessful

Much appreciated

 

[p4nny]

This will work great, thank you. How do I convert a standard formula format to R1C1?

so for example:

=IF(B2="","",IF(Q2<>"","Complete",IF(OR(M2="",O2=""),"Missing Plan Dates",IF(AND(M2>Dashboard!$AB$8,N2=""),"Not started"

 

[Fluff]

Where would this formula go?
for instance if in C2 your formula would start =if(rc[-1]=
if in Z2 you'd have =if(rc[-25]=

 

[p4nny]

Basically, your formula works on any row.

Is there a way I can get my formula to reference the same row as the value entered in column A, just as yours does.

On any row yours will sum the value in column A and column B but my IF statement stays static and references the same cells throughout.

Hope that makes sense

Really appreciate your help here!

 

[Fluff]

try

        Target.Offset(, 4).Formula = "=IF(B2="""","""",IF(Q2<>"""",""Complete"",IF(OR(M2="""",O2=""""),""Missing Plan Dates"",IF(AND(M2>Dashboard!$AB$8,N2=""""),""Not started""))))"

 

[p4nny]

perfect, all working thank you!

 

[Fluff]

Glad to help & thanks for the feedback
Have a good weekend