rajagopal
11-12-2008, 10:32 AM
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...
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...