Hello,
I'm hoping someone can lead me into the right direction.
I have a main sheet called "MAIN" and a source data sheet called "IssueTool".
The "Main sheet has unique account numbers in column J and the "IssueTool" has duplicated account numbers with a year in column F (there are also multiple account numbers within a cell separated by a semicolon. I am trying to figure out a vba code that will match the account numbers. Once the account number is a match in the "IssueTool" sheet, then if the data in column I "Code1" shows the word 'Accepted', then I need to go back into the "Main" sheet and in column AV (Code1) the result should be a 'YES'. If not, then leave blank. If there is no account number in the "IssueTool" sheet, then leave cell blank. The same will be done for all other Code columns and looped for each account number in the "Main" Sheet.
Process:
1. Search for account number from "Main" sheet in "IssueTool" sheet
2. If 'Accepted' is found within the Code columns I thru O in the "IssueTool", then mark as 'YES' is the "Main" sheet respective Code columns AV thru BB ... If not accepted or account number is not found, then leave blank.
Main Sheet:
IssueTool:
Thank you,
I'm hoping someone can lead me into the right direction.
I have a main sheet called "MAIN" and a source data sheet called "IssueTool".
The "Main sheet has unique account numbers in column J and the "IssueTool" has duplicated account numbers with a year in column F (there are also multiple account numbers within a cell separated by a semicolon. I am trying to figure out a vba code that will match the account numbers. Once the account number is a match in the "IssueTool" sheet, then if the data in column I "Code1" shows the word 'Accepted', then I need to go back into the "Main" sheet and in column AV (Code1) the result should be a 'YES'. If not, then leave blank. If there is no account number in the "IssueTool" sheet, then leave cell blank. The same will be done for all other Code columns and looped for each account number in the "Main" Sheet.
Process:
1. Search for account number from "Main" sheet in "IssueTool" sheet
2. If 'Accepted' is found within the Code columns I thru O in the "IssueTool", then mark as 'YES' is the "Main" sheet respective Code columns AV thru BB ... If not accepted or account number is not found, then leave blank.
Main Sheet:
IssueTool:
Thank you,