Leonardo1234
Member
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
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