Thanks in advance for any suggestions for which I will provide feedback.
I am getting an error on the following formula as it's when i added, the "N/A" part for the IFERROR.
Cells(i, 4).Formula = "= IFERROR( MATCH(TRUE,INDEX(Sheet1!E" & i & ":" & LastColumnLtr & i & "<>0,),0)," & ""N/A" )"...