Plz have a look the copy and paste condition are as follows
vba is placed in seperate file
open marks.csv file
open student.xlsx file
if column c of marks.csv file matches with column a of students.xlsx file then copy the yellow colour highlighted data of that row of student.xlsx and paste it to column h of marks.csv file
save and close marks.csv file and close student.xlsx file
and paste only the data means only numbers, not the highlighted colour along with numbers
so plz have a look and do needful
Paste highlighted colour data
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Paste highlighted colour data
Please see my reply here.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Lounger
- Posts: 25
- Joined: 30 May 2019, 18:59
Re: Paste highlighted colour data
Sir i am new to vba i tried by recording macro
but when i done that i was unable do to mange the code means i am new to vba
so plz provide me some guidance so that i can write a code by my own
plz have a look into this and i will learn and understand the code and i will see how the code works and what details are required how to write a code
but when i done that i was unable do to mange the code means i am new to vba
so plz provide me some guidance so that i can write a code by my own
plz have a look into this and i will learn and understand the code and i will see how the code works and what details are required how to write a code
-
- Administrator
- Posts: 78575
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Paste highlighted colour data
Take a look at the questions asked by leonardo1234, umpsbug and roger@. You should find enough to get you started there.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 25
- Joined: 30 May 2019, 18:59
Re: Paste highlighted colour data
sir but in that post nothing is similar to my problem
-
- Administrator
- Posts: 78575
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Paste highlighted colour data
I would recommend that you get a professional Excel developer to write the code for you.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 25
- Joined: 30 May 2019, 18:59
Re: Paste highlighted colour data
fine no problem sir i will get a professional excel developer for myself , this is my last question
I hope u will not disappoint me
I hope u will not disappoint me
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Paste highlighted colour data
We are not trying to be nasty and it's certainly not that we are unwilling to help you, but personally, I see absolutely no attempt from you to even help yourself. You have not proven to us that you even tried something or even recorded some attempt. It's not enough to just say you are new to code or don't know how to write a specific macro as there is so much code samples and starting points out there. Many of the solutions I post for others start by doing a Google search and then tweaking the samples to meet the need. This is very disheartening that you don't seem to want to learn to do things yourself. My experience is that learning is more rewarding and satisfactory in the long run.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Lounger
- Posts: 25
- Joined: 30 May 2019, 18:59
Re: Paste highlighted colour data
ok i will try once again and i will let u know the code