Office Tool/Housing/Judge Lister

Here is a sheet for easy making of separate lists for each judge.

How to:

Step 1.  Enable the macro (left side of formula bar. If not seen, re open the file)
Step 2. Copy the whole timetable in first sheet.

Note: - Cells should be UNMERGED

Note: - Timetables sorted by time give sorted lists for judgers.

Step3. Go to second sheet.

CLEAR THE EXISTING DATA and fill the needed data

Step 4. Click PREPARE LIST button.
Result: Lists are ready in third sheet.

TeachWithIdea blog won't be responsible of any mistake occurs by corrupted code or wrong using

Warning:- This File is only helper and may contain corrupted codes and functions. So, more probably it will kill your whole data or gives back the wrong result. So, check it first more and more. And while using it during the program, keep the whole result separate in a written hard copy. If you came across any error please feel free to mail at muhammedvee@gmail.com

 


Download