Vacation planner / tracker

[Shrinivasa]

I need your support on the VBA codes.

There is a vacation template/tracker and need to be updated vacations which are planned (As PL, CL and other types of leaves)

In the vacation tracker, there are 50+ resources and each resource have some plan leaves and leaves should not cross the 24 leaves per year. So, I need the VBA codes to update the leaves in the tracker with these conditions.

For example:- The resource planned for 10 days leaves from 01.01.2021 to 14.01.2021 (10 working days) and that need to be updated in the tracker and also update the emergency leaves ( If resource had taken the emergency leaves, those leaves also need to be Shuffled with future planned leaves) and Total leaves should not exceed 24 leaves.

 

[The_Macrotect]

It would be helpful if you posted your workbook.

 

[Shrinivasa]

		30-Dec-19	31-Dec-19	01-Jan-20	02-Jan-20	03-Jan-20	04-Jan-20	05-Jan-20	06-Jan-20	07-Jan-20	08-Jan-20	09-Jan-20	10-Jan-20	11-Jan-20	12-Jan-20	13-Jan-20	14-Jan-20	15-Jan-20	16-Jan-20	17-Jan-20	18-Jan-20	19-Jan-20	20-Jan-20	21-Jan-20	22-Jan-20	23-Jan-20	24-Jan-20	25-Jan-20	26-Jan-20	27-Jan-20	28-Jan-20	29-Jan-20	30-Jan-20	31-Jan-20	Total Vacations	Un-planned leave	Total
Emp. Sr. No.	Employee Name	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F
1234567	CHATURVEDI	9	9	9	9	9			9	U	9	9	9			9	9	H	9	9			X	9	9	9	9			9	9	9	9	9	1​	1​	2​
1234567	ARIJIT MITRA	8	8	9	X	8			X	X	X	8	8			8	X	8	8	8			8	8	8	8	8			8	8	8	8	8	5​	0​	5​
1234567	ASHISH KOLLIVALASA	9	U	9	9	9			9	9	9	9	9			X	X	H	X	X			9	9	9	9	9			9	9	9	9	9	4​	1​	5​
1234567	ASHISH PACHAURI	9	9	9	9	9			9	9	9	9	9			9	9	H	9	9			9	9	9	9	9			9	9	9	9	9	0​	0​	0​
1234567	CHATURVEDI																																		0​	0​	0​
1234567	CARLOS	8	8		8	8			8	8	8	8	8			8	8	8	8	8			8	8	8	8	8			8	8	8	8	8	0​	0​	0​
1234567	DEBASIS SEN	9	9	9	9	9			9	9	9	9	9			9	9	9	9	9			9	9	9	H	9			9	9	9	U	9	0​	1​	1​
1234567	SRIVASTAVA	9	9	9	9	9			9	9	9	9	9			9	9	H	9	9															0​	0​	0​
1234567	DAGUET	X	X	9	X	X			8	8	8	X	8			8	8	8	8	8			8	8	8	8	8			8	8	U	8	8	5​	1​	6​
1234567	GOUSEPEERA DUDEKULA	9	9	9	9	9			9	9	9	9	9			9	9	H	9	9			9	9	9	9	9			9	9	9	9	9	0​	0​	0​
1234567	GURURAJ BHAT	X	X	9	9	9			9	9	9	9	9			9	9	H	9	9			9	9	9	9	9			9	9	9	9	9	2​	0​	2​
1234567	JAGADEESH GOWDA	9	9	9	9	9			9	9	9	9	9			9	9	H	9	X			9												1​	0​	1​
1234567	JAGANNATH	8	8	9	8	8			8	8	8	8	8			8	8	8	8	8			8	8	8	8	8								0​	0​	0​
1234567	RENGGLI																	2							2							2	2	2	0​	0​	0​

 

[Shrinivasa]

Please help me, How to find two range values in another sheet and copy those Range data by using VBA ?

 

[The_Macrotect]

In order to help, I'd need to know exactly what you want to copy, where you want to copy it to, and see the other sheet.

 

[Shrinivasa]

Sorry for the delayed

There is a vacation plan file and need to be updated vacations which are planned (As PL, CL and other types of leaves)

In the vacation plan file, there are 50+ resources and each resource have some plan leaves and leaves should not cross the 24 leaves per year. So, I need the VBA codes to update the leaves in the vacation plan from the Automation for Vacation_V1 file ( in the Sheet - Calendar) with the above conditions.

For example:- The resource planned for 10 days leaves from 15.01.2020 to 22.01.2021 (6 working days) and that need to be updated in the vacation plan file from the Automation for Vacation_V1 file ( in the Sheet - Calendar) and also update the emergency leaves ( If resource had taken the emergency leaves, those leaves also need to be Shuffled with future planned leaves) and Total leaves should not exceed 24 leaves.

Here attached sample files