Copy Particular data and display from other XL file without opening

[KumarPK]

Hi Team,

Good Morning

I m New to this forum this is my first ad.

I need help , I am new to VBA, I am facing a problem to solve the below query.

In our school there is a marks sheet of entire academic year of all the students ( Master file ), I have another file to view the particular student all type of marks details, suppose if I enter the student register number, it needs to Display in my view file entire marks status including Test 1 and Mid Term Exam.

Please help me

PFA attachment of sample data

Kumar PK