Hi,

I have a table in excel contains users and tasks planned date wise to them.

If I enter date of a particular date tasks assigned to that date should get listed. Column A contains users Column B, C, D and E contains date as header and numbers below each date. In the next sheet if I enter a date from the list number listed for that particular date should get listed here.

Date 13-Mar 14-Mar 15-Mar r
User 1 10 20 15 45
User 2 25 15 20 15
User 3 10 35 10 20
User 4 15 45 20 10

13-Mar
User 1
User 2 Here it should pull data from the list above bases on date highlighted in Green
User 3
User 4

Thanks.