chester1993
New Member
- Joined
- Jan 26, 2016
- Messages
- 40
Hello, all. I'm looking for some help on a thing I am working on.
On sheet named "status" -which is also the database, you can see columns of information. Basically, what I need help with is I want the data to appear on the calendar I created on "Main Tab" in 1 condition: it is "Approved" as you can see on column F of the "status" tab. The data I want in the calendar is the "Code" in column B.
On column D, it shows "Date" - this is the date when I want to see the code of the employee.
For instance, on the 1st row, the employee code is crobin which has an approved date of 4/1/2021. I want to see crobin under April 1, 2021.
If possible, I also want to see the same code on columns M11:M18. As you can see, if you change your selected date, the date on M10 is also changing.
I really hope some could help me on this. Thank you! Stay safe everyone!
P.S. not sure why but I cant attach my excel file here. So, I am attaching images of the file.
On sheet named "status" -which is also the database, you can see columns of information. Basically, what I need help with is I want the data to appear on the calendar I created on "Main Tab" in 1 condition: it is "Approved" as you can see on column F of the "status" tab. The data I want in the calendar is the "Code" in column B.
On column D, it shows "Date" - this is the date when I want to see the code of the employee.
For instance, on the 1st row, the employee code is crobin which has an approved date of 4/1/2021. I want to see crobin under April 1, 2021.
If possible, I also want to see the same code on columns M11:M18. As you can see, if you change your selected date, the date on M10 is also changing.
I really hope some could help me on this. Thank you! Stay safe everyone!
P.S. not sure why but I cant attach my excel file here. So, I am attaching images of the file.
