Paste highlighted colour data

c@1234
Lounger
Posts: 25
Joined: 30 May 2019, 18:59

Paste highlighted colour data

Post by c@1234 »

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

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Paste highlighted colour data

Post by Rudi »

    
Please see my reply here.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

c@1234
Lounger
Posts: 25
Joined: 30 May 2019, 18:59

Re: Paste highlighted colour data

Post by c@1234 »

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

User avatar
HansV
Administrator
Posts: 78575
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Paste highlighted colour data

Post by HansV »

Take a look at the questions asked by leonardo1234, umpsbug and roger@. You should find enough to get you started there.
Best wishes,
Hans

c@1234
Lounger
Posts: 25
Joined: 30 May 2019, 18:59

Re: Paste highlighted colour data

Post by c@1234 »

sir but in that post nothing is similar to my problem

User avatar
HansV
Administrator
Posts: 78575
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Paste highlighted colour data

Post by HansV »

I would recommend that you get a professional Excel developer to write the code for you.
Best wishes,
Hans

c@1234
Lounger
Posts: 25
Joined: 30 May 2019, 18:59

Re: Paste highlighted colour data

Post by c@1234 »

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

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Paste highlighted colour data

Post by Rudi »

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.

c@1234
Lounger
Posts: 25
Joined: 30 May 2019, 18:59

Re: Paste highlighted colour data

Post by c@1234 »

ok i will try once again and i will let u know the code