find , copy row funcation or highlight row

[jwalkerack]

I guess i have a spreadsheet , that has a lot of data within in it. At the moment i am looking for different company names

So i am searching the company name using the find funcation for example to search for Cola Company

So this would give me back all the Cola Company within the spreadsheet.

i was wondering if its possible to copy the whole row that entry appears on , onto another worksheet. via a macro

Or if that is not possible maybe hightlighting the whole row in a colour