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

[AFANPQ]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]L[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]N[/TD]
[/TR]
[TR]
[TD="align: center"]Potential Overlap[/TD]
[TD="align: center"]No Overlap[/TD]
[TD]Definite Overlap[/TD]
[/TR]
[TR]
[TD][TABLE="width: 417"]
<tbody>[TR]
[TD]
1002302-AFA Data Core R5 Claims (for PAS R2)[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]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>[/TD]
[TD]<strike></strike>1002302-AFA Data Core R5 Claims (for PAS R2) 1002046-Misc. WV Enhancements
1002289-CLAD Support for Remaining DI Contracts<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[/TR]
[TR]
[TD]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>[/TD]
[TD]<strike></strike>1002402-MCP Download (for PAS R1)
<strike></strike>1002447-AF Connect - 2018 Next
1002203-AFenroll: Automated Case Set-up
<strike></strike>[/TD]
[TD]<strike></strike><strike></strike>1002471-AFenroll: Real Time Data Access
1002408-Application Audit Logging
<strike></strike>[/TD]
[/TR]
[TR]
[TD]<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>[/TD]
[TD]1002158-High Net Worth UL
1002463-Indexed UL
1001516-Make Agent Productivity and Sales Force Data Avail
<strike></strike>[/TD]
[TD]<strike></strike>[/TD]
[/TR]
[TR]
[TD]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>[/TD]
[TD]<strike></strike>1002148-DevOps Initiative
1002369-Group Managed Service Account Transition
1002284-Merging HSA/Flex into NCOA
<strike></strike>[/TD]
[TD]<strike></strike>1002151-NCOA Process Update
1002374-OnBase 2017 Production Upgrade
1002398-Simplified Issuance
<strike></strike>[/TD]
[/TR]
</tbody>[/TABLE]
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.