(?<word> \w{4,})
This is a php code that does exactly what I want my macro to do. String together characters a-z and 0-9 (not case sensitive) and match words when they are equal to or greater than 4 characters. I am not sure how to get this code into VBA's language. I need it to loop through a column, find matches, and compare those matches to each other. If they words are a 100% match in two cells I would like them to automatically combine values. If the matched words are similar in two cells, I want it to ask the user if they would like to merge these values together.
Ex:
Project Name | Total Hours |
Mowing the lawn | 2 |
Watering the lawn | 3 |
Planting Trees | 5 |
Mowing the lawn | 2 |
Planting Tree | 3 |
<tbody>
</tbody>
message box:
Planting Trees matched with Planting Tree, would you like to combine these Files? Yes=True No=False
If true, do
If false, do nothing
end result if user picked yes:
Project Name | Total Hours |
Mowing the lawn | 4 |
Watering the lawn | 3 |
Planting Trees | 8 |
<tbody>
</tbody>
end result if user picked no:
Project Name | Total Hours |
Mowing the lawn | 4 |
Watering the lawn | 3 |
Planting Trees | 5 |
Planting Tree | 3 |
<tbody>
</tbody>
</word>