You could have a separate worksheet or a form that gets activated when you
select the student id and this could automatically get the details.

Give more info of the data and we can help you show something.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"yshridhar" wrote in message
...
We maintain school database in excel. The payment particulars are updated
daily, which includes stu-Id, stu-Name, pay-date, Amount, Rcpt-No. Id and
Name are extracted from database using VLOOKUP. Is there any way apart
from
pivot table to get the Ledger form of student pay details, if i select the
stu-Id. Can we use worksheet functions for this?
With thanks