vba excel - worksheet change copy event and target different sheet

Hello. There's a lot of this out there, but I can't find this simple problem. I've got a little snippet to transfer a value to another worksheet:

Please Login or Register  to view this content.

How would one write to a different column though? i.e. copy range A to column C of Sheet 2 directly, same row.

Thank you both. I went with yours skywriter. Thanks for that.