Task List Scheduler

**excelhelpseeker** · 11-11-2017, 01:30 PM

I Have a task list for Team members on daily basis..(see sheet 2 of sample attached)

In sheet1, Team member are allowed to use only column A for entering their respective Emp Id only

For example, emp 101 enter his id in A1, then data in B1 to be populated automatically (considering his first task)

same way, all TM enter their id in column A, gets their task populated....
End of the all total Task of a TM, "No More Task" to be populated (See B11 of sheet1)

Like wise in C column, Reviewer name to be populated except the doer of the task.
For example, of emp 101 is the doer then reviewer should be any other than 101.

Pls help with formula or macro.

**Kaper** · 11-12-2017, 03:12 AM

May be formulas will be enough?
B2:

Formula:

Please Login or Register  to view this content.

C2:

Formula:

Please Login or Register  to view this content.

I left these in row 2, you can copy them down just to test.

If not (as you posted a thread in VBA subforum), you can still use these formulas in a code.

In sheet code (right click on tab with sheet name, and use Display Code):

Please Login or Register  to view this content.

Note that because the above code changes only columns B and C no Application.eventsenabled=false at begining and =true at end of the code is needed.