Add formula to adjoing cells if column A is added to

[redspanna]

Hey all

So I have a Table that currently populates A2:H750
Is there some VB code that I could use that would add the following results when any cell in Column A is newly populated

Column B:
Add this formula =IF(ISBLANK(A762),"",TEXT(Data!$A762,"mmm"))

Column C:
Add this formula =IF(ISBLANK(A762),"",YEAR(EOMONTH(A762,9))-1&"-"&RIGHT(YEAR(EOMONTH(A762,9)),2))

Column D
Add this formula =IF(ISBLANK(A762),"",YEAR(A762))

Column E
Add this formula =IF(ISBLANK(A762),"",VLOOKUP(B762,Workings!$A$4:$C$15,3,FALSE))

Column G
Add this formula =IF(ISBLANK(A762),"",TEXT(A762,"DDD"))

Note: the reference to the column A value would match that of the newly populated cell in column A, so if a value is pasted into A800 then the formulas above would all refer to A800

Thanks in advance