Blocking cells that correspond to data in another tab

[Aestas]

I have 2 tabs, there is data in one tab but only 2 columns that matter - "Primary Consumer" which is a list of 14 clients, and "Publication Date" which is the last time we sent them a communication. I have been asked to create a separate tab calendar visual that automatically populates when we put a date in the Publication Date column in the data tab. So I have dates across the top row and consumer names listed down the first column. If I enter a date of June 28th in the data sheet, I want it to put an X in the cell on the calendar tab that corresponds to that date and consumer. I hope I'm explaining myself ok. I included a screencap of the calendar visual tab I currently have and I have manually entered a few X's to demonstrate what I'd like.

Open to different options, just need a good visual that'll continually update as we put in more dates to show the executives so they are not just seeing a bunch of data in an excel sheet.

 

[etaf]

how about something like
=IF(COUNTIFS(Sheet2!$A$3:$A$17,Sheet1!$A5,Sheet2!$B$3:$B$17,Sheet1!B$3)=1,"X","")

where Sheet2 - has a list of clients and dates

then sheet1 is laid out roughly as you show - difficult to follow images

Book3
	A	B
1
2
3	client1	6/28/23
4	client2	6/30/23
5	client3	7/2/23
6	client4	7/4/23
7	client5	7/6/23
8	client1	7/6/23
9	client2	7/5/23
10	client3	7/4/23
11	client4	7/3/23
12	client5	7/2/23
13	client1	7/1/23
14	client2	6/28/23
15	client3	6/29/23
16	client4	6/28/23
17	client5	6/27/23
Sheet2

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3		6/26/23	6/27/23	6/28/23	6/29/23	6/30/23	7/1/23	7/2/23	7/3/23	7/4/23	7/5/23	7/6/23	7/7/23
4
5	client1			X			X					X
6	client2			X		X					X
7	client3				X			X		X
8	client4			X					X	X
9	client5		X					X				X
10	client6
11	client7
12	client8
13	client9
14	client10
15	client11
16	client12
17	client13
18	client14
19	client15
20
Sheet1

Cell Formulas
Range	Formula
B5:M19	B5	=IF(COUNTIFS(Sheet2!$A$3:$A$17,Sheet1!$A5,Sheet2!$B$3:$B$17,Sheet1!B$3)=1,"X","")

i have added to dropbox - but only for a few days before i delete

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[Aestas]

how about something like
=IF(COUNTIFS(Sheet2!$A$3:$A$17,Sheet1!$A5,Sheet2!$B$3:$B$17,Sheet1!B$3)=1,"X","")

where Sheet2 - has a list of clients and dates

then sheet1 is laid out roughly as you show - difficult to follow images

Book3
	A	B
1
2
3	client1	6/28/23
4	client2	6/30/23
5	client3	7/2/23
6	client4	7/4/23
7	client5	7/6/23
8	client1	7/6/23
9	client2	7/5/23
10	client3	7/4/23
11	client4	7/3/23
12	client5	7/2/23
13	client1	7/1/23
14	client2	6/28/23
15	client3	6/29/23
16	client4	6/28/23
17	client5	6/27/23
Sheet2

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3		6/26/23	6/27/23	6/28/23	6/29/23	6/30/23	7/1/23	7/2/23	7/3/23	7/4/23	7/5/23	7/6/23	7/7/23
4
5	client1			X			X					X
6	client2			X		X					X
7	client3				X			X		X
8	client4			X					X	X
9	client5		X					X				X
10	client6
11	client7
12	client8
13	client9
14	client10
15	client11
16	client12
17	client13
18	client14
19	client15
20
Sheet1

Cell Formulas
Range	Formula
B5:M19	B5	=IF(COUNTIFS(Sheet2!$A$3:$A$17,Sheet1!$A5,Sheet2!$B$3:$B$17,Sheet1!B$3)=1,"X","")

i have added to dropbox - but only for a few days before i delete

Dropbox - File Deleted - Simplify your life

www.dropbox.com

This worked perfectly, thank you!!