How would I put the following onto a single line and have the code still work?
Range("AH2").Formula = "=IF(ISERROR(INDEX('[Daily MI Master Template.xlsm]MI'!$X$86:$X$13952,MATCH(A2,'[Daily MI Master Template.xlsm]MI'!$T$86:$T$13952,0))),"""",INDEX('[Daily MI Master Template.xlsm]MI'!$X$86:$X$13952,MATCH(A2,'[Daily MI Master Template.xlsm]MI'!$T$86:$T$13952,0)))"
Range("AF2:AF" & RowL).FillDown
Bookmarks