Dynamic Calender

[raccoon588]

I have a calendar on one tab and a list with three columns on another tab. The three columns are NAME, DATE OFF, and APPROVED. If the APPROVED column has a yes in it i would like to have the name placed into the calendar bellow the corresponding date. sometimes there may be more then one name assigned to a date.

any ideas on how to go about this?

 

[Perpa]

raccoon588,
You might give this calendar a try...I have used it successfully for several different applications.
Download the macro enabled file from this link:
https://app.box.com/s/b5u2l6zwmphmj6peeuuog7rzhzz7p63b
Save this file with your filename.


Beginning in row 6 (Header Row) of the calendar sheet (Sheet1) thereof,
- Copy your DATE OFF column to column J of the calendar sheet.
- Copy your NAME column to column K of the calendar sheet.
- Copy your APPROVED column to column L of the calendar sheet.


Save your file as macro enabled, .xlsm file extension.


Press Alt+F11 and locate the macro named 'MyHolidays' in Module6.
Change the line of code that reads:

   If Cells(4, "J") = myMonth Then

To this:

   If Cells(4, "J") = myMonth And Cells(rw1, "L") = "Yes" Then

Close the Visual Basic Editor and Save the file.


Manually change the year to the year you want, 2018? You will have to do this each year.
Make sure macros have been enabled, you may have to do this each time you open the file depending
on the version of Excel you are running.


Now change the month by selecting it from the drop down in cell J4.
The dates with 'Yes' in column L should be highlighted and shown in the respective dates of this calendar as shown below.
Perpa


Sheet1

	B	C	D	E	F	G	H	I	J	K	L	M
3										Select Month from Drop Down
4					JULY		2018		JULY	<=======	in this box
5
6									DATE OFF	NAME	APPROVED
7	SUNDAY	MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY		7/3/2018	George	Yes
8	1	2	3	4	5	6	7		7/4/2018	Tex
9			George						7/10/2018	Sam	Yes
10									7/20/2018	Mike	Yes
11	8	9	10	11	12	13	14		7/30/2018	Tim
12			Sam						7/30/2018	Tom
13
14	15	16	17	18	19	20	21
15						Mike
16
17	22	23	24	25	26	27	28
18
19
20	29	30	31
21
22
23

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Perpa]

raccoon588,
The image below is a better representation of the finished look. Don't know why Excel Jeanie distorts everything like that.
Perpa