I would like to use vba to loop through all the worksheets in an Excel workbook to create vlookup formulas on a master sheet. The 3 columns on the master sheet are J, K and L and formulas are below for the master sheet. There are 150 sheets with varying number of rows. The vlookup formulas are on the master sheet and pull data from the 150 sheets. Also, some of the worksheet names have special characters. Each record has a unique ID in column A which is the lookup value.
Can you provide code that might accomplish this. Thanks
sample vlookup for the first sheet of 150
Column (J) Conflict is Justified? (Y/N) : =VLOOKUP($A$2:$A$10202,Adrian_Luster!$A$2:$L$47,10,FALSE)
Column(K) Justification :=VLOOKUP($A$2:$A$10202,Adrian_Luster!$A$2:$L$47,11,FALSE)
Column(L) Mitigating Controls for Conflict : =VLOOKUP($A$2:$A$10202,Adrian_Luster!$A$2:$L$47,112,FALSE)