Trouble highlighting row data.

[Davio]

TABLE1		J	A	N	U	A	R	Y
	1	2	3	4	5	6	7	8	9	10
TEAM1	X	X	X				X	X
TEAM2			X	X	X	X	X
TEAM3									X	X

<tbody>
</tbody>

TABLE2	TASK	START DATE	END DATE
TEAM1	Y	1jan	3jan
TEAM2	X	3jan	7jan
TEAM3	B	9jan	10jan
TEAM1	X	7jan	8jan

<tbody>
</tbody>

I am having issues with TABLE1 highlighting the start and end dates from TABLE2. My goal is to have the data from TABLE2 visualized in TABLE1 The task data does not factor in to the visualization represented in TABLE1. any help or advice is appreciated.​

Thank you.

 

[Davio]

Peter,

The links below are screenshots of my workbook, VBA Code and summary sheet.

Workbook-https://drive.google.com/open?id=1w9...x04IAZ4MZlqLUj


VBA Code-https://drive.google.com/open?id=1Tc...nWpXxd07Uzn2y7


Summary Sheet-https://drive.google.com/open?id=1JW...6QcGtCaHqJNL3M



I am trying to create a summary sheet where I can view and compare both the coaches and their team schedules in one place. All sheets are identical except for the type of training, start dates and end dates. Each sheet consists of three to five teams along with their calendar schedule highlighting the training, start dates and end dates.Each of the coach's names are represented on the tab. My end result is that the calendar information will be pulled from each individual sheet and compiled onto the summary sheet, but instead of showing the teams, it will show the coach's names.

Please let me know if you need and more information of screen shots.

Thank you.​

​

 

[Peter_SSs]

The links below are screenshots of my workbook, VBA Code and summary sheet.

That is pretty much what you showed us in post 29 so I don't think it adds anything for me.
Could we see a small example of sheets NAME A and NAME B and what the resultant SUMMARY SHEET would look like?

 

[Davio]

NAME A

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
2		Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue
3		1-Sep-19	2-Sep-19	3-Sep-19	4-Sep-19	5-Sep-19	6-Sep-19	7-Sep-19	8-Sep-19	9-Sep-19	10-Sep-19	11-Sep-19	12-Sep-19	13-Sep-19	14-Sep-19	15-Sep-19	16-Sep-19	17-Sep-19	18-Sep-19	19-Sep-19	20-Sep-19	21-Sep-19	22-Sep-19	23-Sep-19	24-Sep-19	25-Sep-19	26-Sep-19	27-Sep-19	28-Sep-19	29-Sep-19	30-Sep-19	1-Oct-19	2-Oct-19	3-Oct-19	4-Oct-19	5-Oct-19	6-Oct-19	7-Oct-19	8-Oct-19	9-Oct-19	10-Oct-19	11-Oct-19	12-Oct-19	13-Oct-19	14-Oct-19	15-Oct-19
4	TEAM-1										STRENGTH																											ENDURANCE
5	TEAM-2																									CARDIO
6	TEAM-3																																					ENDURANCE
7	TEAM-4										JUMPING JACKS
8	TEAM-5	ENDURANCE																													CROSSFIT
9	MISC EVENTS
10	Report Period	Sep-19															Oct-19
11
12
13
14
15
16
17	TEAM NAME	TRAINING				START			END
18	TEAM-1	STRENGTH				10-Sep-19			20-Sep-19
19	TEAM-2	CARDIO				25-Sep-19			2-Oct-19
20	TEAM-3	ENDURANCE				7-Oct-19			15-Oct-19
21	TEAM-4	JUMPING JACKS				10-Sep-19			10-Oct-19
22	TEAM-5	ENDURANCE				1-Sep-19			10-Sep-19
23	MISC EVENTS	HALLOWEEN SPECIAL				25-Oct-19			31-Oct-19
24	TEAM-1	ENDURANCE				7-Oct-19			15-Oct-19
25	TEAM-2	STRENGTH				19-Oct-19			29-Oct-19
26	TEAM-5	CROSSFIT				30-Sep-19			8-Oct-19

<tbody>
</tbody>

NAME A​

NAME B

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT
2		Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue
3		1-Sep-19	2-Sep-19	3-Sep-19	4-Sep-19	5-Sep-19	6-Sep-19	7-Sep-19	8-Sep-19	9-Sep-19	10-Sep-19	11-Sep-19	12-Sep-19	13-Sep-19	14-Sep-19	15-Sep-19	16-Sep-19	17-Sep-19	18-Sep-19	19-Sep-19	20-Sep-19	21-Sep-19	22-Sep-19	23-Sep-19	24-Sep-19	25-Sep-19	26-Sep-19	27-Sep-19	28-Sep-19	29-Sep-19	30-Sep-19	1-Oct-19	2-Oct-19	3-Oct-19	4-Oct-19	5-Oct-19	6-Oct-19	7-Oct-19	8-Oct-19	9-Oct-19	10-Oct-19	11-Oct-19	12-Oct-19	13-Oct-19	14-Oct-19	15-Oct-19
4	TEAM-1										CROSSFIT																											CARDIO
5	TEAM-2																									STRENGTH
6	TEAM-3																																					ENDURANCE
7	TEAM-4										VACATION-VACANT
8	TEAM-5	NO TRAINER AVAILABLE
9	MISC EVENTS
10	Report Period	Sep-19															Oct-19
11
12
13
14
15
16
17	TEAM NAME	TRAINING				START			END
18	TEAM-1	CROSSFIT				10-Sep-19			20-Sep-19
19	TEAM-2	STRENGTH				25-Sep-19			2-Oct-19
20	TEAM-3	ENDURANCE				7-Oct-19			15-Oct-19
21	TEAM-4	VACATION-VACANT				10-Sep-19			10-Oct-19
22	TEAM-5	NO TRAINER AVAILABLE				1-Sep-19			22-Oct-19
23	MISC EVENTS	HALLOWEEN SPECIAL				25-Oct-19			31-Oct-19
24	TEAM-1	CARDIO				7-Oct-19			15-Oct-19
25	TEAM-2	STRENGTH				19-Oct-19			29-Oct-19

<tbody>
</tbody>

NAME B​

I am unable to copy the summary sheet with the combined information from NAME A and NAME B. I've attached a link to show how the summary sheet should look
<strike></strike>SUMMARY SHEET
https://drive.google.com/open?id=1JWf43Kuk9iaU6Awx166QcGtCaHqJNL3M

 

[Peter_SSs]

Thanks for the additional info. Unfortunately, I don't see an easy way to achieve that. I think probably a bit much to try to achieve in a forum like this but you never know, somebody might chime in with a good idea.

 

[Davio]

I have a temporary fix by using a linked photo of the ranges. Somehow it does not copy the entire highlighted portion.