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

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
You can simply filter on 1 and paste the visible rows to all sheet

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!