Using VB to code sheet formulas
 

Hi,

I have 3 sheets in a workbook.

1. Bank
2. MIS
3. Temp

Bank sheet:
Formula columnB from B13 to end of column depending on ID in
corresponding column D
=IF($D13="","",IF(COUNTIF(List,$D13),VLOOKUP($D13, List,
3,FALSE),"Incorrect or New ERP ID
"))

Formula columnC from C13 to end of column depending on ID in
corrsponding column D
=IF($D13="","",IF(COUNTIF(List,$D13),VLOOKUP($D13, List,
2,FALSE),"Update List"))

Formula in columnM from M13
=IF(COUNTIF(MIS!$A:$A,S13),VLOOKUP(S13,MIS!$A:$Q,8 ,FALSE),"")

Formula in columnN from N13
=IF(COUNTIF(MIS!$A:$A,S13),VLOOKUP(S13,MIS!$A:$Q,1 1,FALSE),ABS(0))

Formula in columnS from S13
=F13&J13

------------------------------------------
MIS Sheet:
Formula in columnA from A2
=K2&G2

Formula in columnR from R2
{=INDEX(Bank!B:B,MATCH(A2,Bank!S:S,0))}
------------------------------------------

Temp Sheet:
I have a named range 'List' from this sheet which is being used in
bank sheet to vlookup.


Required:
I would like all the formula calculations in VB for both Bank & MIS
sheets.