Hi, I have this set of data
[TABLE="width: 500"]
<tbody>[TR]
[TD]Car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Mondeo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Fiesta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Honda Civic[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Toyota Prius[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]brands[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[/TR]
[TR]
[TD]Honda[/TD]
[/TR]
</tbody>[/TABLE]
I try to write a macro which adds brands into collection/range and then check, if there is this substring (brand) in a range.
Any hints?
Thanks a lot in advance
[TABLE="width: 500"]
<tbody>[TR]
[TD]Car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Mondeo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Fiesta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Honda Civic[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Toyota Prius[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]brands[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[/TR]
[TR]
[TD]Honda[/TD]
[/TR]
</tbody>[/TABLE]
I try to write a macro which adds brands into collection/range and then check, if there is this substring (brand) in a range.
Any hints?

Thanks a lot in advance