Hi,

I've seen threads similar to this before, however I don't know much about macros so I'm having trouble translating similar macros into one that fits the column/cell/sheet names as mine.

So in Sheet1 of my file I want to copy out all rows that contain "Milka" in column I. This column contains other names in each cell, but I just want to take out ones that contain Milka (can contain other names also).

And I want to copy these rows into Sheet 5.

Any help from you excel geniuses would be much appreciated! :)