Rahuladitya
New Member
- Joined
- Jun 16, 2010
- Messages
- 5
Hi Friends.
I need help to display data of one sheet to another.
Its attendance sheet. Containing name of students and date. The date column has two values A and P.
Now what I want, I want to display name and date for students who are absent (when value is A{Absent}) to an another sheet of same file.
File name Monthly Attendance, it has two sheets Absent Tracker, and Attendance.
If a student is absent on a particular date I want to display his/her name along with the date coping from Attendance sheet to Absent Tracker sheet when he/she is absent. There may be more than one student absent on a particular day so the same information of all absent students should show in different columns.
Will appreciate you quick response.
I need help to display data of one sheet to another.
Its attendance sheet. Containing name of students and date. The date column has two values A and P.
Now what I want, I want to display name and date for students who are absent (when value is A{Absent}) to an another sheet of same file.
File name Monthly Attendance, it has two sheets Absent Tracker, and Attendance.
If a student is absent on a particular date I want to display his/her name along with the date coping from Attendance sheet to Absent Tracker sheet when he/she is absent. There may be more than one student absent on a particular day so the same information of all absent students should show in different columns.
Will appreciate you quick response.
