delivery

Good morning gang. Hope you're all well. My question is around a worksheet I have like this: <tbody> Division Business Unit ID Owner Value Steam Tier Status Championship Delivery 1 14 John Smith Stream 4 Tier B Good Championship Delivery 1 14 John Smith Stream 2 Tier A Good Premier...

Hello Everyone, Happy New Year ! Hope you all had a nice time with your Family, Friends, Relatives.. Starting a New Year with a new challenges on Excel ! :) Basically I'm trying to build a 'Goods In' spreadsheet. Made the macro which gives unique ID for each delivery we are getting in...

HiEveryone, I'm going round in circles and cannot figure out a formula for thebelow, I really need some help. The criteria needs to determine whether a specific delivery date is greaterthan 70 days from a given date(this could be a date in the future or the past)and return a specific value...

Hello, I'm trying to do a case statement in VBA. If the value in J is >= 200 AND <300 I want it to say in O REGULAR DELIVERY PV, when >= 300 AND <400 I want it to say REGULAR DELIVERY PV300, and when >= 400 REGULAR DELIVERY PV400. This does not work. Sub VolumeChange() '...

I may have just figured it out but I thought I would throw it out there and see if anyone has a different solution. I work a pizza delivery company and I get a printed out receipt for each delivery I make. On there is a delivery date, order number, order time, order out, address, etc. I created...

G'day guys - we have 2 sheets sheet1 and sheet2 both sheets can go down to row 10,000 JOB ID is found in Column C and Delivery Price is found in Column I. We have the below: What we found was because Vlookup is finding the first entry with BLANK it returns BLANK as you'd expect - however we...

I have data with different delivery dates in another sheet. I want to do conditional formating that makes the lead time light pink if it is 2weeks pass each delivery date. I think sumifs with conditional formating could work

I am trying to write some VBA to solve a distribution hub to destination resupply problem. I have over 20 potential destination locations but calculate resupply one location at a time. The destination location can be supported from 30 different supply locations. I built a formula that looks up...

Hi all, I'm new to this forum. I'm stuck with something. I need to estimate delivery cycles. I have dates on column B <tbody> B 1 Delivery 2 January 10 3 February 11 4 March 15 5 April 22 </tbody> I need to get average days between the delivery dates I could do it like this...

Hello, Hope someone can help with this. I have a worksheet with a list of products, dates, delivery locations and amount being delivered (units). The products can be duplicated, as can the dates, but the delivery locations will be different if this is the case. <tbody> Product Date Delivery...

Hey guys, I need some help. I've been frying my brain trying to get a formula but all I get is a circular reference. Someone told me to write a macro to do it which I have no clue how to do. I have the following 6 columns: 1. Column A: Day {Mon..Sun} 2. Column B: Demand [kg] 3. Column C...

Hi, I am trying to calculate the next available delivery date , either Tuesday or Thursday based on the date given in Q10 first but N10 if there is a date entered The delivery slots would be only weekday Tuesday or Thursday, excluding the weekends many thanks for any help

Dear All, At work we order stock from the factory for orders we have from customers, so we set a Date Of Delivery so we know when to input this order in our system. What I want to achieve is that via a VBA code is to check the "Date Of Delivery" and send out an email to myself 7 days before the...

Hi, I am trying to calculate a delivery slot from a date given in N11 or M11 if N11 is blank The delivery slots would be only weekday Tuesday or Friday many thanks for any help

Hi, We have recently purchased a barcode scanner to scan all of the products that get delivered to us and what we want to do is check against the delivery note to see if we have received everything on the sheet. What I am looking at is something along the lines of: We have a tab with an...

My excel skills are very rusty and out of date. I have spent over three hours trying formulas I found with google but couldn't make anything work. Figured it was time to learn how to use a forum and ask for help.. This is my way of saying you're probably going to have to dumb down your answer...

Hi, I've been thinking to solve this problem for a while but to no avail So I got bunch of raw data with delivery guys who would do shipment in a month like this <tbody> MON-1 TUES-1 WED-1 THURS-1 FRI-1 SAT-1 MON-2 TUES-2 WED-2 THURS-2 Andrew 12,00 12,00 12,00 Ashely 12,00 11,00...

<tbody> </tbody> please can someone help with these 2 things i need a formula to exctract the number this one Delivery Area: 01 - Glasgow / Edinburgh i need the "01" and this one Company Code: 99 & 499 Delivery Yr/Wk: 2018 / 12 Product Category: ALL CATEGORIES i need the "12"...

Hi, can i please get some help. I am trying to work out this formula, similar to the one i used earlier but now altered. In cell A2 I have concatenated data from cells A5 and B5. I did this because I have a mix of numbers and text. That formula lives in cell A2. In the category cell B4, that is...

I'm really hoping someone can help. I have tried the general solutions a google turns up with no joy. Using these calculations return the VALUE error as the source workbook is closed. Could someone take a look at these and convert them so they work when the workbook is closed...