Previous Topic Next Topic

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

Answer 1 / 1

So record a macro and perform those functions. Then when you need it again, hit the quick key and viola!
Report

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
Report
Blocked Profile
Do you mean, you cannot record a macro?
Report
> 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
Report

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
Ask a question