let me explain it to u in detail....suppose i m making a record of an college
which includes name,permanent addess,hostel name,phone no etc....now i also
want that i get hostel specific records also(for that i have made diiff
sheets namely hostel 1,hostel 2 etc)...i want that when i enter hostel 1 in
the hostel coumn of the main sheet, the name,address etc go to the sheet of
hostel 1 automatically....