Macro to scan column and copy corresponding cell

[RobbieMoulton]

Hi,

I'm trying to write a macro that scans a column in a worksheet, and if it finds a cell that meets a certain criteria, it pulls a cell from a different column (but the same row) into a different worksheet.

To simplify it:
I need a macro to scan the entire Column C on 'Sheet1' for a cell that has the value '1'. If it finds a cell with this value, it copies the value from the same row in Column A and pastes it in the last active cell in 'Sheet2'. The macro then continues down Column C in 'Sheet1' searching for the next cell with the value '1' to copy the corresponding value in Column A into the next row in 'Sheet2', etc...

If someone could help me with this, it would be much appreciated.
Thanks.