Calling Cell for name on basis of changing number 0,1.

Closed
Tanveer Ali - Nov 12, 2014 at 11:16 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 15, 2014 at 06:55 AM
Dear. I have attendance sheet name "Attendance" of 70 people. having table of their names in 1st Col and Absent in 2nd Col. Absent col changes everyday by 1 or 0 means who absent so 1 come in front of his name and else 0. so I make table of Absent People Name in other sheet renamed "ALL". Now I want that when I enter "1" in Attendance sheet means some one is absent so their name should come in sheet "ALL" where I shows Just absent People. when I enter another "1" in Attendance sheet means now 2 people are absent so its name also come in row 2 of sheet "ALL".

Thanks
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 15, 2014 at 06:55 AM
You can simply filter on 1 and paste the visible rows to all sheet
0