Copy data from one sheet to another based on condition using VBA

[Closed]
Report
Posts
3
Registration date
Monday July 11, 2016
Status
Member
Last seen
July 18, 2016
-
The data looks like this
A B C D
1 3.45 2.34 3.67 34.67
2 45.2 54.78 39.6 3.56
3 5.90 3.78 8.65 3.78
4 47.89 23.56 34.67 34.6
I need VBA code to automatically copy data from Column C at row 2 and Column C at Row 4 to another sheet