On Sheet 2 I have a matrix of 1600 rows by 5 columns (however this will grow
in rows and columns). In column C the values are unique (actually Company
symbols).
On sheet 1, I want to enter a number of company symbols (ranging from one to
many)
And then I want to use a 'macro' (or equivalent) to:
- look at the list on Sheet 1
- go to Sheet 2
- Find the same values
- Highlight the entire row(s) and /or copy them
- Paste them to a third sheet
I do not know VBA very well, so any suggestions are very much aprreciated

I am using Excel 2003 (on my PC) and then migrating the result to Office
2004 for Mac.