Hi All,
CoverageCalendar2.0.xlsmI have created the attached workbook which acts as a crew calendar. It allows users and supervisors to create vacation leave requests, supervisors can approve the requests and add them to the "calendar" sheets where other techs can see what shifts are available by clicking on the shapes. The part I am having trouble with is when a new request is made, the shape is being pasted in the last active cell in the calendar sheet instead of under the correct date of the leave request. Can anyone check this out and tell me where I am going wrong? I understand some of the code is redundant and needs to be optimized which I plan to take care of after I get all parts of this working. Thank you for your time.
CoverageCalendar2.0.xlsmI have created the attached workbook which acts as a crew calendar. It allows users and supervisors to create vacation leave requests, supervisors can approve the requests and add them to the "calendar" sheets where other techs can see what shifts are available by clicking on the shapes. The part I am having trouble with is when a new request is made, the shape is being pasted in the last active cell in the calendar sheet instead of under the correct date of the leave request. Can anyone check this out and tell me where I am going wrong? I understand some of the code is redundant and needs to be optimized which I plan to take care of after I get all parts of this working. Thank you for your time.
