Hope someone can help me out with this question
I have a sheet with a range of data. Column A includes a code, and columns C - I the data I want to copy onto another sheet.
Cell C3 includes a validation list of all the possible codes within column A.

What I want to do is this:
If the user selects a particular code from the list in cell C3, a macro looks up the data in range A10:I50 and whenever the same code appears in column A of that range, it copies the contents of columns A, and I for that particular row to sheet2.

Let me know if I havent explained it well. And thanks for any help
Amy xx