EXCEL VBA - Loop through range/collection

petrcz

New Member
Joined
Mar 25, 2016
Messages
31
Hi, I have this set of data

Car
Ford Mondeo
Ford Fiesta
Honda Civic
Toyota Prius

<tbody>
</tbody>

brands
Ford
Honda

<tbody>
</tbody>


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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,089,687
Messages
5,409,788
Members
403,278
Latest member
mairis

This Week's Hot Topics

Top