driver

Hello, I wonder if anybody can help me out. I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values. I was able to do this so far with Index, Match and Countif array formula but it only works for...

Hello, I need to email out a list of individual reports to specific addresses. The reports are located in C:reports and all have the same naming convention. Below is an eg of the spreadsheet and the data. Paste starts from A1 <tbody> AssetName Driver email Manager email1 Manager email2...

Hi, I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle. Abbreviation codes: Driver Code GU- Gurdeep G- Gafar G1- It will show the that driver done the multi delivery in this trip. For Example- On 2 June Gafar driver done four trips (G1 to G4)...

Hi Guys I have maintenance old macro, this macro work in WinXP 32bit & Office 2010 but now user need to upgrade computer into Win10 x64 & Office 365 there are a problem when accessing this code data_path = Left(ThisWorkbook.Path, 31) cn_bank.Open "driver={Microsoft dBase Driver...

Hi everyone, I want to make a pivot chart to track performance of drivers in a race series. I can make it as a normal chart, but would like the have the filter options to remove certain drivers, or compare directly. I'm unsure on how to layout the data source, and seem to be having issues...

Hello, is it possible to query (select) a mySql database (WordPress) with VBA ? and if so, how ? do I need to install some driver or somthing else ? Thanks !

Hello all, This is my first post here so hello everyone, pleased to meet you all :) I'm a self taught Excel user so my skills at this stage are unfortunately a bit limited and quite rough on the edges as well. I recently started working for a new company and I'm working on a spreadsheet...

Hello everyone, I have worked with PowerPivot for my own uses a fair ammount, but recently I was asked to create some reports for other users, and I am getting connection issues that I dont understand when they try to refresh the data source connection. I will put the error message bellow, but...

Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...

Hi everyone. Need help please. We have a spread sheet for monitoring drivers mileage and work times as sample below. Date Driver Start Work Finish Work Start Milage Finish Milage Time Work Milage Total Time Total Milage 1/9 Ted 06:00 13:00 100 150...

I am looking for a formula to do this if possible, but VBA will work if not available as a formula. So, in column A there are dates, column G has a driver name, column L has either LF or DT two show either landfill or downtime status. Over in column R I have weights of the landfill load, but...

I would like to compare 2 separate columns and list out unique rows in another sheet. Column 1 Column 2 Column 3 Column 4 Column 5 MOW204000235 1 No No Vehicle Maint. MOW204000235 1 Yes No Driver Fitness MOW204000235 1 No Yes...

Hi All, I have a pivot table which contains a row of months with a column of employees. I have sorted the data with highest scores first, but don't know how to write a formula which returns with the top 5 highest/lowest employees per month. Also, as in the example below, there are blanks in...

Hello, I have the below formula: ="The average driver worked an average of "&ROUND(AVERAGE(F48:G48,H48,F49,G49,H49,F50,G50,H50,F53,G53,H53,F56,G56,H56,F57,G57,H57),0)&" hours per week" The above gives an answer of "The average driver worked an average of 2 hours per week"... I need an answer...

Hi, I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart); <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody>...

Good morning All, I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening. However when I try opening the workbook using a Mac (my boss's machine), it comes up with the following...

Afternoon all, I need some help. I would like to create a 6 week rota that show 15-20 drivers shift pattern. Now this is where it gets complicated. I need to it be easy for me to print and hand to a switch board operator and understand. So the rules are: Driver 1 will work 4 x 12 hours days on...

I am developing a file that will need to be used by only 2 people at the same time but the file contains code and userforms. The file will consist of the following sheets Drivers Master List Driver List Availability Master List Availability List The initial data will be added via a userform...

Hi, Not sure what / how to do this. I need to lookup vehicle registration number + data as per below (below is what I have in one excel tab. Date Van Reg Driver Name 23/10/2017 ABC 123 ? The other tab contains...

Hello All, how can I convert multi rows data into single row using power query.. My above column must look like the below comlumn.. Thanks.. <tbody> Driver Name Driver ID Bus Number School ID School Name Timing David 1005 F5002 A123 Helen Model School 7:15 David 1005 F5002 A300 Stuart High...