engineer

Hi There I have created the attached planner/job board and require help in doing the following. 1. Under the days of the week. if a date range is entered i want it to auto colour the cells under days of the week. 2. in the engineer list section if i set and engineer to on holiday or sick, i...

Hi all I am trying to create a spread sheet version of a project/ job board our job board look like this. Month: September Week Commencing Date: <tbody> Engineer List/Assigned to Engineer List/Assigned to Monday Tuesday Wednesday Thursday Friday Andy John Tesco...

I have a spreadsheet which is used to add in the vacancies which are closed. As you can see there is a reference number, a date and the title of the vacancy. I want to highlight every 6th occurence of the Administrator vacancy for the records to be audited. I want all fields in the record to...

Excel macro code for below requirement I have a sheet "Daily Report" which contains 3 Pivot tables for 3 different staff. the pivot table is populated based on the vlookup of the data from various other sheets Engineer 1 Column C - Date of the activity Column D - Name of the staff Column E -...

Hi Folks, Appreciate your help here, I have few items needed below for my reports and refer to requirements and concerns. Is there a way I can automatically compute the time at B (1st Worksheet) to the corresponding Engineer Grade and Rate per hour base from Engineer name (Section A)? My...

always feels good to come back to Mr. Excel, feels like I'm learning something new. Anyways, I have a master sheet of accounts with a state they are located in. On another sheet I have an engineer assigned and multiple states they will cover for those accounts. Sheet 1 Company A, CA, insert...

Probably a daft question, and Im thinking I need index match as vlookup can only look up one result, but I'm hoping somebody can help I have a list of Job numbers. Sometimes these job numbers are repeated as more than one engineer worked on them, so I wish to look up the job number, and it...

I am trying to develop a formula that calculates the anticipated end date of project tasks utilizing the WORKDAY(start_date, days, [holidays]) function for use in conditional formatting based on: 1) provide start date using a named range "start_date" 2) length of projects in weeks (to the...

Hi guys, I am trying to get an average time on site for service engineers on regular visits to regular customers from 2 sheets. Sheet one has a manually filled log listing engineer, customer and time on visit in date order. Sheet 2 lists all customers in 1 column, then counts visits to each...

Hey,I have a sheet of Engineers Name with allocated complaint numbers and their mobile number. i want to create a Macros script so that every time i apply filter on a particular engineer and press a Macros Created Keyboard short cut it copies engineer mobile number. Engineer Mobile Number...