Copy from other XL file and display only particular data without opening the XL file

[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 of particular student.
Please help me
PFA attachment of sample data
Kumar PK

 

[vletm]

This could give one kind of 'basic' idea.
You make a link to 'another file' and
search with it 'student row' from 'Master file'.
Like:
'another file' cell [A1] is used for row, cell [A2] is used for column,
cell[A3] is '=index('Master file';A1;A2)' and cell [A4] is used for 'the wanted student register number'.
Next You'll do some VBA-code which sets cells [A1] and [A2] to wanted values. You will get 'Master file' answer from cell [A3]
Like:
[A2] = 'Master file's student register number column'
[A4] = 'wanted student register number'
y = 0 ' the 1st row' - 1
do
y = y+1
[A1] = y
loop until ([A3] = A4) or (y > 9999) ' some kind of max limit!
After You have find 'the row', You'll find the another values too.
I can give more details, if You're interesting in this ... Okay

 

[p45cal]

PFA attachment of sample data

Nope, can't find it.

 

[NARAYANK991]

Hi ,

Why not have everything ( both the master data and the dashboard to view any individual student's details ) in the same file ?

Narayan