Previous Topic Next Topic

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

Closed
tunnde80
Posts
3
Registration date
Monday July 11, 2016
Status
Member
Last seen
July 18, 2016
 - Jul 18, 2016 at 11:39 AM
 tunnde80 - Jul 22, 2016 at 09:54 AM
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
Related:

1 reply

Answer 1 / 1
Blocked Profile
Jul 18, 2016 at 06:00 PM
So record a macro and perform those functions. Then when you need it again, hit the quick key and viola!
0
tunnde80
Jul 21, 2016 at 12:09 PM
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
0
Blocked Profile
Jul 21, 2016 at 03:47 PM
Do you mean, you cannot record a macro?
0
tunnde80 > Blocked Profile
Jul 22, 2016 at 09:54 AM
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
0
tunnde80
Jul 22, 2016 at 08:44 AM
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
0