route

Hi Guys, I am looking to get a macro created for an excel sheet, I have tried searching on here and cannot come across anything. I have a sheet that contains a list of all the departure times and assigned route number and amongst other details. Departure times is in A3 onwards to 400+ And...

Good afternoon! I have been poking around trying to find something that might help me and I have tried a few things and I am not having any luck. I would like to create a list for myself to help route deliveries. Each driver will do the same route a little differently based on their own...

Hi, everyone! I have what I think is an easy question. I have a spreadsheet where column A is route numbers, and column B is item numbers. I need to highlight rows that have the identical route number and item number. Example Row 1: route 1 item D4 Row 2: route 1 item C3 Row 3: route 1 item...

Hello, I need to extract the route number, which can be between 1 to 3 digits, see example below: Route 1-1 South Route 26-7 Ludlam Route 29-2 West Route A 101-1 North As you can see the Route value and (-) dash character are constant. Is there a formula in excel and/or PowerBi I can use...

Good day I have workbook with multi sheets named as today date in each sheet column x route nam the count of this route in column y I'm creating macro to copy all route with unique value and paste the result in sheet (main of month) column Aa. I want to compare column x in all sheets with column...

Hi, i need some help. I try to google but see hard for me :( In myweeksht; At Column D 1. Find WPxx And Replace with 'Poster' 2. Find number (the number can be single or double digital) And replace with 'Route' <tbody> Col D Col D (Result) WP1 find WP @ Col D & replace with 'Poster Poster...

I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...

<tbody> A B C D E F G H I J K L M Date Route Product 1 Product 2 Product 3 MAY May 1 3 23 32 29 Route P1 P2 P3 May 2 5 35 53 71 3 May 3 6 14 27 12 4 May 4 5 18 81 65 5 April 30 3 54 19 21 6...

I'm looking to modify a VBA code to create a unique date and time stamp. The code I have so far is Sheets("Route Import").Cells(x, 1).Value = Int(CDbl(Now())) This gives me the integer value of the date but I also need the time because the macro I'm using will go to the next line and...

Looking for help. I would like to create a formula that would pull in employees name/s. I have a database I type in employees names and the route each person is assigned to. Each route has its own tab. I want he employees who belong on the route/tab to auto populate. The crew may be one or 6...

Hello, Good day I have 15-20 workbooks, where in in every workbook the 2nd sheet name would be " Route sheet ". I want a Macro which can consolidate all the data from these workbooks in the same formate. All 15-20 workbook " route sheet " formate will be same. can any one help me in this...

I have considered Excel, Business Intelligence as career. I want to learn basics but don't know where to start. Can anyone please guide what should be the route. Power Pivot, Power Query or BI. Shall be thankful to all of you

I have a Spreadsheet which I have linked to other sheets effectively, (thanks to this board). I now want to go one step further and be able to write in a name in a column and within the same column, return a number (in this case a duty no.) I have tried Vlookup, if and match and so far, I have...

Hi, I am trying to turn a text list into a table. The list is approx 60 'routes' as similar to below. I would like use a macro to turn this into a 60 row table. What is the best was of achieving this? Many thanks, Rich From a text list:Route *TEST_AD* User 1 name: Business Unit...

Hi, I currently have an Excel spreadsheet one sheet has a listwith all my job data. I have a separate sheet with my selection criteria andthen I wish to populate another sheet based on the selection criteria do youknow if this is possible if so how do I go about doing it. For Example: - Data...

Hello, I have two columns in my workbook Column A - lists dates Column B - lists route numbers There are several duplicates since there is a row for each shipment done by the route each day. I need a formula to tell me how many unique days the route operated. See below - BCG1A operated 1...

Hi all, Every Keyword has a route associated with it. I want to find out which description contains the keyword and then post the associated route for that keyword . For example, Abrasive is associated with Route 22. I want to match the Description "Large Abrasive Tool" to the keyword...

Hello all 1st post on the forums but have been a long-time browser :) I am wondering if anybody can help point me to some good MapPoint resources or can help me with some code. I think what I am trying to do is quite simple but struggling to get started. In Excel, I will have a list of...

Dear Team, Do needful as iam having txt fine contains data in below mention format ================================================================================ TRAIL EXT_NPLC_VERIZON COMMUNICATIONS INDIA PVT LTD_4 MBPS_0127402731980_SRF-731980-100915-VC12_01...

Hi!! Im wondering if anyone can help, below is the code ive written so far and as it is, works well but what i need is the route number to be a variable which can be read from a cell range ie if the route range is C1:C70, it uses the value of C1 then moves onto C2 then C3 etc, im not sure whats...