Array Macro to Loop through many rows and 3 columns possibly using IF THEN ELSE statement

[AFANPQ]

L	M	N
Potential Overlap	No Overlap	Definite Overlap
1002302-AFA Data Core R5 Claims (for PAS R2) <tbody> </tbody> <strike></strike>	<strike></strike>
1002289-CLAD Support for Remaining DI Contracts 1001142-Claims Audit Report 1002368-Cyber Security Monitoring 1000896-Data Warehouse Pending Reserves Enhancements 1000986-Enhance 1099 Rejected Payment Report 1002005-Flex Task and Productivity Reports 1002284-Merging HSA/Flex into NCOA 1002006-Misc. CLAD Enhancements 1002046-Misc. WV Enhancements 1002445-Plan ID <strike></strike>	<strike></strike>1002302-AFA Data Core R5 Claims (for PAS R2) 1002046-Misc. WV Enhancements 1002289-CLAD Support for Remaining DI Contracts<strike></strike>	<strike></strike>
1002470-AFenroll: New User Interface (easier self-enroll) 1002467-AFenroll: Product Development Tools 1002471-AFenroll: Real Time Data Access 1001806-Brochures Management Tool 1002500-Enrollment Program 1002402-MCP Download (for PAS R1) 1002030-Selerix Triggers xmit Status in AFenroll - AIR 1002398-Simplified Issuance 1002018-Update Display Descriptions and Census Extract for 1002270-WSL A1274 - turn off application 1002447-AF Connect - 2018 Next 1002203-AFenroll: Automated Case Set-up 1002470-AFenroll: New User Interface (easier self-enroll) 1002467-AFenroll: Product Development Tools 1002471-AFenroll: Real Time Data Access 1002408-Application Audit Logging 1001806-Brochures Management Tool 1002500-Enrollment Program <strike></strike>	<strike></strike>1002402-MCP Download (for PAS R1) <strike></strike>1002447-AF Connect - 2018 Next 1002203-AFenroll: Automated Case Set-up <strike></strike>	<strike></strike><strike></strike>1002471-AFenroll: Real Time Data Access 1002408-Application Audit Logging <strike></strike>
<strike></strike>1002165-DataRobot 1002158-High Net Worth UL 1002463-Indexed UL 1001516-Make Agent Productivity and Sales Force Data Avail 1001475-OPUS Web Illustration and eApp 1002445-Plan ID <strike></strike>	1002158-High Net Worth UL 1002463-Indexed UL 1001516-Make Agent Productivity and Sales Force Data Avail <strike></strike>	<strike></strike>
1002148-DevOps Initiative 1002369-Group Managed Service Account Transition 1002284-Merging HSA/Flex into NCOA 1002151-NCOA Process Update 1002374-OnBase 2017 Production Upgrade 1002398-Simplified Issuance <strike></strike>	<strike></strike>1002148-DevOps Initiative 1002369-Group Managed Service Account Transition 1002284-Merging HSA/Flex into NCOA <strike></strike>	<strike></strike>1002151-NCOA Process Update 1002374-OnBase 2017 Production Upgrade 1002398-Simplified Issuance <strike></strike>

<tbody>
</tbody>

I am trying to understand how to build a macro that will do something as follows: If string is added to Range ("M2:N2") Then remove string from "L2" and loop through all used/populated rows in these columns. All help is appreciated since I am very new to VBA.

 

[synergy16]

need a little more information on this. any string? and what do you mean remove string from L2? there are a lot of strings in L2, which one would you want removed?

 

[AFANPQ]

Thanks for your questions.

"any string? and what do you mean remove string from L2?" An Example: If string "1002046-Misc. WV Enhancements" (Found in "L3") is added to "M3" or "N3" Then remove string "1002046-Misc. WV Enhancements" from "L3"

there are a lot of strings in L2, which one would you want removed? So, any string or maybe substring if that's what I should refer to it as, that is included or added to any of the corresponding Column and Row should be removed. In addition each string should only exist in 1 of the 3 columns.

 

[synergy16]

i see. so if a string is entered to m3 or n3 and that exact same string appears in l3, remove it from l3. JUST l3 or any row in column 3?

 

[AFANPQ]

Just L3

 

[AFANPQ]

Just L3 in relation to M3 and N3
L4 in relation to M4 and N4 and so on

 

[synergy16]

ok to just check against the numerical values? its a little safer, then you dont have to force CAPS and worry about misspellings.

 

[AFANPQ]

Checking against numerical values would work great! Each number is assigned a unique text string.