Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Range(NewColLtr & "2").Value = "=IF(A2=(IFERROR(INDEX(" & Chr(39) & NewSheetName & Chr(39) & "!" & NewColumnLetter & ":" & NewColumnLetter & ",MATCH(A2," & Chr(39) & NewSheetName & Chr(39) & "!" & NewColumnLetter & ":" & NewColumnLetter & ",0))," & Chr(34) & "False" & Chr(34) & ")),HYPERLINK(" & Chr(34) & "#" & Chr(39) & NewSheetName & Chr(39) & "!" & Chr(34) & "&ADDRESS(MATCH(A2," & Chr(39) & NewSheetName & Chr(39) & "!" & NewColumnLetter & ":" & NewColumnLetter & ",0),COLUMN(" & Chr(39) & NewSheetName & Chr(39) & "!" & NewColumnLetter & ":" & NewColumnLetter & ")), " & Chr(34) & NewSheetName & Chr(34) & ")," & Chr(34) & " N/A " & Chr(34) & " )"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
