Automatic updation

[rajagopal]

Hi,
I've an excel sheet which has the consolidated data.
I've another sheet named as 'Form' in the same excel file.

In the sheet 'Form', when i enter the Student number in cell B6, the details in the range B8:B33 to be automatically populated using the data available in the consolidated sheet.

Few Student numbers will appear repeatedly 2 or 3 or 4 times in the consolidated data but with different details.
for Ex. student no. 1001 appears 2 times in the consolidated data,
I want the respective details to be populated under column Data 1, Data2.

If Student no. 1001 appears 10 times, I want all the 10 details under separate column headings like Data1, Data2..Data10.

Hope my requirement is clear. I attached my working file for your ref.
Please help...


Thanks...

[RonMcK]

Just a random observation: Looking at your 'Consolidated Data' sheet, the Student Number is not unique by student. If I'm in your file 5 times, each of my entries has a different Student Number. Here's a screen capture documenting this issue.


Thanks,

[rajagopal]

It's unique for every student.
Only for a small population, the student will have multiple information under the same Student number.

the logic is the student might have done UG in multiple streams or UG & PG in the same college.

[rajagopal]

The below KB post can help you in counting the number of repeated sequences..
http://vbaexpress.com/kb/getarticle.php?kb_id=708