Byline Delivery Order Template Made Easy

Byline delivery order template

hello I'm your boon welcome to my Channel today I would like to share with you on how to create dynamic delivery order without using VBA in a Sun what is dynamic delivery order ok I show this is a dynamic delivery order ok so they mean it controls many is an active which control many's delivery order by this number okay let's say this is 1 0 0 1 you give you the this particular switch can be useful for now okay so in the same chain-3 you have all the particles related to 1 0 0 3 if they say you chain to 6 this then you chain do this so this is called dynamic delivery order so why we want to create dynamic division others because what's just the manual type whereby I've seen my customer before decrypt the degree order decree this ok they save the 1 0 0 1 they save in one sheet followed by 1 0 2 1 0 3 1 0 4 and so on maybe I show you under 10 then he can go to until 100 200 300 for small companies they wish low capital to purchase a mainframe for did rely on a cert spreadsheet to create a delivery order so this one is also applicable to sales order or chess on the invoice and other similar documents ok so the benefit the benefit is it is you all these particulates but when it is in control you can use the data to create I say a summary report erode occur summary report that is weekly monthly or daily also can nearly up to you because you have the full data once you create a dynamic delivery order similar to mainframe but is a smaller size okay so to create this the panic to create this dynamic deal water is not that it's easy so maybe you you you can take bigger few hours or maybe less than that why because this technique does not involve VBA again so it's very flexible so this one we need to know few a cell function only a simple Excel function which you already know right it's only how to cook with this a third function I give you the best dish so cook your way with a cell function okay so to start with we create this tree this tree she okay so for Leo kingship is you is a normal that holiday but for this do-kyun you have to have the rule of thumb that is the do must be in ascending order secondly okay so if let's say you have to item okay or do you have to tie him to semen same do number with the different particular Xie so number three you got seven items you have to type in order seven year old number same with all the particle different but close for Y and so on unti thousand on whatsoever okay so secondly you have done do or the ship this is called active ship which is controlled by this as six control by this so we started we say 1 0 0 1 yeah ok we start 1 0 to 1 so once we complete this one starting the rest I Lester active I was a delta which we're going to pull from here using making use of this your number we leave it blank the rest we maintain right fixed okay so once complete we go to here ok so the first thing we have to link that the OL number to the computation ok so the computation is for you when we link to this we want to do the computation I mean a server to the computation from this and return back the particles that this do 1 I mean you will pull from this data and return this to this area so that means okay the first thing with this do number we need to know in from here how many I turn this do number have let's say 1 we have 1 2 we have 2 3 we have 7 4 we have 1 5 a.m. to 6 p.m. 3 like that ok so for this we need to use a simple was a cow we function equal okay so cow it with range range we go here we select the whole range comma and back to the computation okay this is the criteria they study on number okay so we have one yeah so you see your number we have one item okay so let's say we change the 1 0 0 3 we have 7 see ya we have seven yeah seven okay so this is formula first times right yeah so secondly we need to know the what is the row position of the do I first position on the first item on the do number I mean for 3 is 5 okay for 1 is 2 then for 2 is 3 okay so for this we use a mesh function ok so the first item between your first item I mean we use mesh mesh mesh lookup value here comma back to here then it must include the heading that is important and this is an SMS okay we are fine okay so secondly we need to know how to find the rest of the this is fine I mean the rest will be 6 to 11 okay tell me you go but you how to fine so for this we use if function compared to the count here compared to the town to find the second item that is we we put a second item yeah maybe item here so we copy down we to track never not sure China okay okay so so this location is based on this the size of the do here the size here and this is this is trap then this one will be true because you must cover the full you'll assess based on this okay so here if function if this one is less or equal to this one these are count item so we have to lock this one and if weaker we have the first row 1 plus 1 okay if not we blanket oh yeah 5 6 7 so we copy now then we have 11 items okay now we have all the rows number D 4 1 0 0 3 so on the next step is to extract all the item so we copy here so for this computation we don't care about formatting or whatsoever this one we just you know okay because it will be hidden anyhow we must know name so to extract this we use a Asian Cup function ish function okay look up for the title in this so we have this okay so this one since we want to copy down we must do some locking the min is chained to absolute along the heading we love the range and we long the column number let's say we copy that copy down we've pasted reference because this one is blank this one is blank old and there's no reference this one give us problem because a black no problem so we have to use a real function to clear the blanket I mean this one if error plane not maintained so once complete then we are fully we extract fully array and let's say we change this number to John so once complete fully we need to link all this back to this fourth day equal the day this day know format is ok this is your number this is deliver to deliver to and this is customer customer you must take the first row cannot because sometime in the first only one night Germany so then this one is under number and so up here we down okay this so for this one with number we put one okay the first I've done surely go number one so in second if let's say we use formula if this one equal blank so the term blank else let's see so we somehow Verde Creek was a dynamic delivery order so for testing we put in let's say six six oh I mean did you see that we we have one do formatting so we do for meeting you let say want to do photo this we just follow this format painter go here and this so we have all these you see I mean this is dynamic so one we already complete all this we want to say only one too long all this so only allowed this to be editor so to do this we do love user new okay okay okay okay then we love it that's so let's say we can change this so that mean this is called dynamic delivery order okay you don't I'm going to show you let's go and once auto I want auto fit in another version so before that okay so this one at once Peter is is using Excel spreadsheet to create video we'll be able so let's say we delete this thing okay I mean let's say I mean once we delete all it will show you on the LSA i order stop here I only use until the TC 2501 night 0 and if I under one night zoom because there's nothing here okay so if let's say I I said that maybe on 23 so this so you wait 23 then the rest Widow say if I say that here under okay so if I say I did it this so this is all the 700 okay I mean you let say for so this is how our future was a video blog from thank you very much see you