transmittal

I have a spreadsheet to track documents issued, when and a transmittal number. The transmittal can have multiple documents and each document can have multiple revisions. Where I am stuck is trying to format this data into a report based on documents or on transmittal. I have tried using a...

i would like to calculate how many item outstanding will be due on weekend in N/A and blank in the range. <tbody> Item Mail No. Date Received Type Forwarded Date Response Response Date Due Date Day Process Status Days Overdue Remarks 9 SSP-PDP2-WTRAN-856277 01/01/2019 Workflow Transmittal...

Hello All, I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet...

Hello All, I have made two previous codes that copy cells from one sheet that is a form and paste them in the next blank cell on another sheet that is a Log sheet. They looked something like this: If COStatus = "INITIATED" Then InitiatedDate = ActiveSheet.Range("F3") 'Copies Values...

Hi all, i have a workbook containing 2 worksheets. One is called "Transmittal" and the other is called "SAP". The transmittal worksheet is basically a template form that employees use to enter debits and credits. The SAP worksheet is basically a summary or a simple list of the same debits and...

I have a large table that contains a lot of due dates (column L), as we get to these due dates we enter transmittal numbers into a separate column (column B) . In the due date column (L) I would like the dates that are within 30 days highlight yellow and within 7 days highlight red. I would also...