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