I am trying to match accounts from one sheet with a master list in another sheet. I am then trying to past info from the corresponding account to three columns to the right in my master sheet but when I a have an account that does not exist in the master I get a run time error.
Here is the code that I have. Any help is appreciated
I have tried to use the application.match function in vba but that has cause many errors. Thanks in advance
Here is the code that I have. Any help is appreciated
VBA Code:
If IsError(Cells.Find(What:=FindCell).Offset(0, 6)) = True Then
FindCell = 0
Else
Cells.Find(What:=FindCell).Offset(0, 6).Select
If Columny > 0 Then
ActiveCell.value = Columnx & "/" & Columny
Else
ActiveCell.value = Columnx
End If
Range("B2").Select
End If
I have tried to use the application.match function in vba but that has cause many errors. Thanks in advance
Last edited by a moderator: