How to update a value from one sheet to another

[Ashti]

Hi,
I am building a leave planner
I have a workbook with multiple sheets
Each sheet represents a department and their students and the dates
I have a summary sheet which should display for a month , who are on leave and for how long

How do we read the A from sheet 2, get the dates and input it Sheet1. keeping in mind it should reflect the month chosen in the period field

Sheet 2:

JULY
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
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
STudent 1					A	a	a
STudent 2
STudent 3

Sheet1:

Period is a drop dwn - July to Dec

STUDENT NAME	VACATION START DT	VACATION END DT
Student 1	6-7-2020	8-7-2020

 

[CA_Punit]

Is there any reference to Department in your summary Sheet. If there are multiple department then you have to either consolidate all the department in one sheet or provide a Department column in your summary sheet

 

[Ashti]

How can I upload the doc here?

 

[CA_Punit]

Use google drive or use xl2bb

Xl2bb is an addin whcih is available in right hand side of reply box

 

[Ashti]

 

[Ashti]

EMPLOYEE NAME	START DATE	END DATE	# OF DAYS TAKEN
Student1			0​
Student2			0​
Student3			0​
Student4			0​