leave

Hi All, I need some guidance and ideas on how to Fill each Employee names if their status is "Vacation Leave" to the corresponding date of the calendar sheets. For example on the image below, In row 3, Robert Downey Jr. and Chris Evans should be filled to January sheet (cell G8 and G9) in...

How can I sort columns A:C using VBA but leave the others columns untouched? Column A needs to be sorted from A2 down and in ascending order.

Sir, I have employees leave details as shown below. If I fill the leave dates in Cells ‘C3’ and ‘D3’ and the status in ‘E3’, the relevent cells for those dates needs to be highlighted. These colours should also needs to change in line with the status in column ‘E3’. The below schedule is...

Hi everyone,I am trying to create a spread sheet that adds up my staff's hours worked for a rolling 119 day period, sounds easy but I have to ignore any day that they have taken as leave but still include a 119 day period. For example if I had a member of staff who took 6 days off in that 119...

Hi I have one condition in below if "S" is found in B16 but would like to add PT so if "S" or "PT" is found then SUM if not leave cell blank =IF(ISERROR(SEARCH("S",$B16)),"",IF(SUM($BO16,$BF16,$AW16,$AN16,$AE16,$V16,$M16)=0,0,SUM($BO16,$BF16,$AW16,$AN16,$AE16,$V16,$M16))) Thanks for any help...

Hi there, I'm working on my very first pivot table :) I'm not sure this is possible but it seems like it should be: My pivot table counts the number of hours taken for different types of special leave (column), by all the staff members/teams (rows/slicer) in our organization. An instance of...

Please help me below. Hope someone can help me, I have two workbook like below: Workbook 1 As below: <colgroup><col width="72" style="width: 54pt;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5"> <col width="112" style="width: 84pt...

I have created an annual leave tracker for use at work. My problem is that although you can pick from a dropdown A/L pending, A/L Approved and A/L denied, with conditional rules to change colours, at the moment anyone with access can at the moment do all three. Is there a way to ensure that only...

How do I extract a letter from a group of numbers and put in into a different cell. For example: Cell B6 has A123456 and I want the letter A taken and put into cell A6 and leave the rest of the number in B, if B doesnt have a letter in it, then leave the A cell blank and color it yellow. Thanks

Afternoon, I am looking for advice or suggestions. I work on an annual leave tracker over various branches in the state and am looking for the most effective way of calculating leave availability balances against various leave codes plotted in with a Macro. I am using a current format where...

Hello How to leave only letters (element symbols) in a range of cells. The range begins at E1. Each element (Ex. Al240 %) is one cell. Make this: <tbody> Al240% As189% B208% C165% Ca393% Co340% Cr267% Cu327% Fe249% Mn_Calc. Mo386% Nb400% Ni341% P177% Pb220% S180% Sb206% Si_Calc. Sn326%...

Here's the formula; =COUNTIFS('Employee Leave Tracker'!$B$4:$B$100,B8,'Employee Leave Tracker'!$C$4:$C$100,">="&$C$7,'Employee Leave Tracker'!$D$4:$D$100,"<="&$C$7) Conditions are; B8 = Name1 C7 = 30/04/2018 'Employee Leave Tracker'!B4 = Name1 'Employee Leave Tracker'!C4 = 30/04/2018 'Employee...

Hi, I have an annual leave workbook that keeps holiday details for around 60 staff There is a worksheet for each of the 12 months where leave is entered - Staff members in Column A, other varying data in columns C:H, leave is captured in columns I:AN I have an additional sheet called...

hi, wondering if anyone can help me solve this for work, ive assigned my drivers an id number and managed to pull there deliverys into a table, only problem is they can leave and return and leave again in the same day, each day is split into leave and return, im trying to get each 'id'...

Hello, I hope someone can help me. this has been driving me crazy for a few weeks. I have 2 sheets, one named inventory and another named orders. on the orders sheet I want to be able to do a vlookup to the inventory tab and display the qty in stock, but then if the same item is listed on...

Hi Team, I have a capacity sheet for resources project wise and the requirement is that if any fresource resigns and if goes on Exam leave for a duration then in those months instead of capacity(No's) R for resignees and EL for exam leave should reflect and it should not calculate their...

Dear Mr.Excel, kindly need your advice how is formula to COUNTIF function ? if I would like to : 1. I have data regarding annual leave monitoring for staff of company which there is a regulation internally that the staff could take annual leave for 1 day and half day. for half day leave will...

Hi I have two reports to check the attendance, one is attendance tracker which we update manuualy in excel. In coloumns headings are names, dates (for example, column A has name, b has 1st march, c has 2nd march and so on.) row waise it has absent, priveledge leave or sick leave. Report 1...

I have a work schedule, that I would like to be able to use 1-10 in B5 (LD as it shows on this screen ) and have it update the leave days in G5:AH41 the days of the week as it shows on this screen (based on the master list of leave days on another sheet.)I used =vlookup...

Hello everyone: I am currently using Index,Match to match records from one sheet to the other. Works great, except when I have multiple records with the same identifier. Let me explain: The sheet named Open Leave Report contains the raw data (lookup values), while the sheet named Open Leave...