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
-
 tunnde80 -
Hello,
Please i need help on extracting some data in excel.

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
Please I need VBA code to automatically copy data from Column C at row 2 and Column C at Row 4 to another sheet. Thank u

1 reply


So record a macro and perform those functions. Then when you need it again, hit the quick key and viola!
ac3mark thank you, i appreciate this information, but the am unable to write the VBA code to do the work. Thank you for the help
Blocked Profile
Do you mean, you cannot record a macro?
> Blocked Profile
The one to perform this function, yes i can not record it but *on the excel surface i have used index and Match command to do it in which at each time i manually enters new range among the same sheet where to pick the data i want. Thank you
The one to perform this function, yes i can not record it but one the excel surface i have used index and Match command to do it in which at each time i manually enters new range among the same sheet where to pick the data i want. Thank you