shipment

<tbody> Order No Order Status 1234 Shipped 2/20/19 1235 Shipped 1/5/19 1236 Prepped for Shipment 1237 Shipped 3/1/19 1238 Shipped 3/10/19 1239 Shipment Confirmed 1240 Shipped 2/15/19 1241 Prepped for Shipment 1242 Shipment Confirmed </tbody> I would like...

I am working on a file which has lot of data, I want to know how many days it took for a particular shipment to close ? File looks somewhat like this. Data looks somewhat like below : <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> Date Shipment 1/2/2019...

hi guys, Need some help on a file that needs filtering though a drop down list. Background: there are different quality of oil shipments that we are getting from the supplier vs the contracted quality that we agreed upon. Every sample of oil is presented into a table called the crude oil...

As you can see in the image, I am trying to merge multiple spreadsheet with the name "xx" & "xxx" into the master spreadsheet "Shipment Combine"? can someone please list their macro here. Thank you.

Folks, I have two columns in "Data Source" sheet. Column B contains of shipment type while column C contains of sequence number. In column B, consist only of: SS or STS (shipment type) In column C, consist of: DT-SS-XXXX if shipment type in column B is SS, and DT-STS-XXXX if if shipment...

I have the following table sample. I need to indicate in the Shipment column,the first time something with the unique ID , the 2nd.. etc. it has to be based on date and not location in the sheet. And if the ID does not repeat then it is the 1st shipment...

Hi i have big problem. I tried many times but i dont know how to prepare vba code which help me to to assign value when is the same from one column to another.it means that <tbody> Date Shipment date Product index 01/01/2018 01/01/2018 W10-1 02/01/2018 01/01/2018 W10-2...

Hey guys. So I have an automation that processes a lot of manual files. It's admittedly a bad process. On one file the user keeps submitting the data with one of the worksheet names with a space at the end. They either submit it as "Shipment" or "Shipment " My code as seen below does not...

Hi This is my first post so I hope I am doing everything correctly. I have 2 tabs of data one for imports and one for exports. What I need to do is: If cumulative value of exports is less than the imported volume of shipment 1, return the reference for shipment 1. Once the volume of shipment...

I have a table below. Column A represents the shipments that are consolidated into one single load. Is there a formula I can put in column B to automatically figure the number of shipments? each shipment is separated by a comma. thanks <tbody> A B Shipment Number Total Shipments...