Frank Bacchus
Member
All
I have a spreadsheet with tasks (text information) listed in column K cells, formatted as follows:
(1) 1. Completed Initial application latency study for critical applications b y Q3, 2015, 08/31/2015 - Completed
(2) Perform latency testing and remediate applications as needed by:
GCC - On-Going - 05/10/2016
SCC - On-Going - 07/22/2016
SRDC - Not Started (Analysis in progress) - 08/05/2016
Definitions:
Completed Tasks: When a listed task has “Completed” before the end of the line it is considered a “Completed Task”.
NonCompleted Tasks: For tasks without the word “Completed” before the end of the line, this is considered a “NonCompleted Task”. There will be a date at the end of the line in mm/dd/yyyy format.
Proceess
I would like to:
1) Create a macro that takes in a number from a screen input - number of days.
2) From top to bottom in the K cell, by pass the completed tasks.
3) Go to the first NonCompleted task and select the date from the end of the task line
4) subtract today's date from the date selected from the task line.
5) if the result is less than or equal to the number of days from the input then place a RED "Y" in the Column “S” cell and proceed to the next "K" cell. Perform same validation until all K cells with text have been evaluated.
Thanks in advance. See Example:
frank
__________________________________________________________________
I have a spreadsheet with tasks (text information) listed in column K cells, formatted as follows:
(1) 1. Completed Initial application latency study for critical applications b y Q3, 2015, 08/31/2015 - Completed
(2) Perform latency testing and remediate applications as needed by:
GCC - On-Going - 05/10/2016
SCC - On-Going - 07/22/2016
SRDC - Not Started (Analysis in progress) - 08/05/2016
Definitions:
Completed Tasks: When a listed task has “Completed” before the end of the line it is considered a “Completed Task”.
NonCompleted Tasks: For tasks without the word “Completed” before the end of the line, this is considered a “NonCompleted Task”. There will be a date at the end of the line in mm/dd/yyyy format.
Proceess
I would like to:
1) Create a macro that takes in a number from a screen input - number of days.
2) From top to bottom in the K cell, by pass the completed tasks.
3) Go to the first NonCompleted task and select the date from the end of the task line
4) subtract today's date from the date selected from the task line.
5) if the result is less than or equal to the number of days from the input then place a RED "Y" in the Column “S” cell and proceed to the next "K" cell. Perform same validation until all K cells with text have been evaluated.
Thanks in advance. See Example:
frank
__________________________________________________________________
Mod edit : thread moved to appropriate forum !