dispatch

Hi everyone, this is my first post, so apologies if I make any mistake in posting here. I have been browsing through the forum and found some similar threads but none that really matched my problematic. I am currently managing the stock and dispatches for the company I work for. In my...

Dear All Excel Experts , My job requires me to send Text message to our vendors to dispatch the materials which contains the following information Supplier Name : Longzhen Model NO : S25 Material Name : Colorbox Qty : 500 pcs Address: Room 505 , Commercial Plaza , 104 Road , Unit 2 , Baoan...

I am curious if anyone could help me. I am looking to add a job number cell on my company dispatch sheet. Is it possible to have an auto generating job number cell that includes a 3 letter prefix for company name plus date and job number? An example would be like this..... 19-ABC-05-001...

Good evening - love this forum! I am working with the county and trying to figure out how many times multiple departments are communicating at the SAME TIME to our dispatch center. There is this misnomer (which I am trying to prove with data) that the times that different departments queue up...

Hello, I have tried searching for the answer, but dont really no what to search. Effectively i have sheet 1 and Sheet 2, sheet 1 has all the products , sale and dispatch dates, sheet 2 just lists all the products, for example A-Z Sheet 1 <colgroup><col width="135" style="width: 101pt...

Dear Excel Community, Currently I have a parameters table that looks like this. <colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody> Type AB A AB A AB A AB A AB A AB A Dispatch 50 10 50 10 50 10 50 10 50 2 10 2...

Hey Folks, I'm trying to display only the value of 'Master List'!B:B where 'Dispatch'!$A$1 appears in 'Master List'!A:A. <tbody> Data on ''Master List' Sheet is manually altered Desired Display on Contracts Sheet Desired Display on Dispatch Sheet BD Orientation Business Cards Chevron...

Dear All, I do have a small data set across A1:C4 as follows:- <tbody> Dispatch Day Leadtime Proposed Delivery Day Thursday 7 Thusday Wednesday 4 Sunday Friday 8 Saturday </tbody> I would like to forecast the delivery day based on the Dispatch Day & the corresponding leadtime. For...