Previous Topic Next Topic

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

Closed
tunnde80 Posts 2 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

1 response

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

Similar discussions

Macro to move data between sheets on condition
Carrie -
vcoolio -

3 responses
Macros: Copy Invoice Details From One Sheet to Another
Jenny -
vcoolio -

6 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
How to copy data from one sheet to multiple sheets using IF
SK -
vcoolio -

3 responses
Copy Rows from one sheet to others based on a condition
EmrsnMktgAnyst -
TrowaD -

6 responses
Macro to copy data to new workbooks based on condition
hosinsul -
ac3mark -

1 response