deadlines

My VBA macro runs reports from Excel to generate a Word doc with upcoming deadlines/due dates. However, I can't figure out how to include a description of the upcoming deadlines/due dates when I run macros. Here are the columns that I need help with: COLUMN A = MATTER NAME COLUMN K = TASK...

I am a complete VBA novice and searched this forum to solve my issue but I still can't figure it out. I have a workbook with 3 worksheets and need a pop-up when opening the workbook. All the info for the pop-up will be derived from the 1st sheet which is named "OpenCases" Here is a screenshot...

Hi Everyone, I nice complicated one this time. I'll try explain the best I can, please ask if you need anything clarified. I have a macro that goes down my calendar sheet and adds in the dates of all my apointments The problem is that if I already have an appointment that day it gets...

Hello Everyone, This is my first post here and also my first question. Every week I extract a data set from a web-service that serves many functions. One of these functions involves action plans that the business has to follow. These action plans have deadlines. Is there any way that I...

Hey y'all I was just wondering if it was possible for excel to run a macro or condition that gets rid of deadlines that have passed and move the next deadline(s) up the table?

Hi, Just need formulas to calculate the date and time P3 and P4 work orders that have two types of deadlines. E.g P4 have 5 business days deadline for response time, and 10 business days until it must be completed. P4 received at 24/05/17 10:30am, has Response time due on 31/05/17 10:30am...

Good Afternoon All, I am currently working in a humanitarian organisation that has many projects running on tight deadlines. I have each of my activities in a different row, with start and end dates in the next columns (G6:G146 and H6:H146 respectively). I would like to apply conditional...

Hello fellows, im facing a problem with automatically sending email to specific mail recipients. I have a file, where i have in column "F" certain date, in column "G" is the state, if the deadline is met or not (OK/NOK). It would be easy to write a macro for this, but this is, where my problems...

Hello, First time poster and I have a quick question! I am essentially trying to create a formula that will determine if someone has met their due date based on the expected due date vs actual completion date. I would like it to generate a yes or no (or something of that variation) so I can...

I have created a trademark tracking spreadsheet (which I was trying to attach but cant quite figure out how to do). I am stuck on highlighting cells when a due date is approaching. For example, I have a formula in cell M1 that returns a due date of 6 months from the date in cell L1. Now I want...