Hello
Please help me to find how to get 3 different output file with 3 different Input file in one excel workbook based on certain colour condition.
Example:-
File- 1
Product ID | Product Name | 1st level Approval status | Date | 2nd level Approval status | Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 |
23456 | N | In Transmit | 10/19/19 | Submitted | 10/19/19 |
98766 | Z | Accepted | 12/13/19 | Not sent | 12/13/19 |
45678 | A | Accepted | 11/25/19 | Accepted | 11/25/19 |
32156 | B | Rejected | 12/13/19 | Rejected | 12/13/19 |
23457 | C | WIP | 10/29/19 | In Transmit | 10/29/19 |
45678 | W | Submitted | 12/11/19 | In Transmit | 12/11/19 |
12980 | X | Accepted | 12/11/19 | Accepted | 12/11/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 |
234568 | Q | In Issue | 10/27/19 | Submitted | 10/27/19 |
98765 | s | Accepted | 12/13/19 | In Transmit | 12/13/19 |
File 2: -
Product ID | Product Name | 1st level Approval status | Date | 2nd level Approval status | Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 |
23456 | N | In Transmit | 10/19/19 | Submitted | 10/19/19 |
98766 | Z | Accepted | 12/13/19 | In Issue | 12/13/19 |
45678 | A | Accepted | 11/25/19 | Accepted | 11/25/19 |
32156 | B | Rejected | 12/13/19 | Rejected | 12/13/19 |
23457 | C | Rejected | 10/29/19 | May get Rejected | 10/29/19 |
45678 | W | Submitted | 12/11/19 | In Transmit | 12/11/19 |
12980 | X | Accepted | 12/11/19 | Accepted | 12/11/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 |
234568 | Q | In Issue | 10/27/19 | Submitted | 10/27/19 |
98765 | s | Accepted | 12/13/19 | In Transmit | 12/13/19 |
File 3:-
Product ID | Product Name | 1st level Approval status | Date | 2nd level Approval status | Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 |
23456 | N | In Transmit | 10/19/19 | Submitted | 10/19/19 |
98766 | Z | Accepted | 12/13/19 | In Issue | 12/13/19 |
45678 | A | Accepted | 11/25/19 | Accepted | 11/25/19 |
32156 | B | Rejected | 12/13/19 | Rejected | 12/13/19 |
23457 | C | Rejected | 10/29/19 | May get Rejected | 10/29/19 |
45678 | W | Submitted | 12/11/19 | In Transmit | 12/11/19 |
12980 | X | Accepted | 12/11/19 | Accepted | 12/11/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 |
234568 | Q | In Issue | 10/27/19 | Submitted | 10/27/19 |
98765 | s | Accepted | 12/13/19 | In Transmit | 12/13/19 |
One OUTPUT File Require with different tabs-
Colour Condition as follow:-
In Transmit -Yellow
Accepted - Green
Rejected, May get Rejected & In Issue - Red
Solved! Go to Solution.
Hello @Rajeev18,
Done, this time it takes only data from the day before.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
@afv2688 . Unfortunately this is not giving the required result, could you please re look into this and share the rectified details.
one simple example- - Considering today's date -7 March 2020, then i would require data for date 6th march 2020.
Input file:-
Product ID | Product Name | 1st level Approval status | 1st level Date | 2nd level Approval status | 2nd level Date | 2nd level Approval status | 3rd level Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 | Rejected | 03/06/20 |
23456 | N | In Issue | 10/19/19 | Submitted | 10/19/19 | Submitted | 03/06/20 |
98766 | Z | Accepted | 12/13/19 | In Issue | 03/06/20 | In Issue | 12/13/19 |
45678 | A | Accepted | 11/25/19 | Accepted | 11/25/19 | Accepted | 11/25/19 |
32156 | B | Accepted | 12/13/19 | Rejected | 12/13/19 | Accepted | 03/06/20 |
23457 | C | Rejected | 03/06/20 | May get Rejected | 03/06/20 | May get Rejected | 12/12/19 |
45678 | W | Submitted | 12/11/19 | In Transmit | 12/11/19 | Rejected | 12/11/19 |
12980 | X | Accepted | 12/11/19 | Accepted | 12/11/19 | Accepted | 12/11/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 | Submitted | 03/06/20 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 | Accepted | 03/06/20 |
234568 | Q | In Issue | 03/06/20 | Submitted | 10/27/19 | Submitted | 10/27/19 |
98765 | s | Accepted | 12/13/19 | Rejected | 12/13/19 | In Transmit | 12/13/19 |
Output file data require like this:-
Product ID | Product Name | 1st level Approval status | 1st level Date | 2nd level Approval status | 2nd level Date | 2nd level Approval status | 3rd level Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 | Rejected | 03/06/20 |
23456 | N | In Issue | 10/19/19 | Submitted | 10/19/19 | Submitted | 03/06/20 |
98766 | Z | Accepted | 12/13/19 | In Issue | 03/06/20 | In Issue | 12/13/19 |
32156 | B | Accepted | 12/13/19 | Rejected | 12/13/19 | Accepted | 03/06/20 |
23457 | C | Rejected | 03/06/20 | May get Rejected | 03/06/20 | May get Rejected | 12/12/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 | Submitted | 03/06/20 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 | Accepted | 03/06/20 |
234568 | Q | In Issue | 03/06/20 | Submitted | 10/27/19 | Submitted | 10/27/19 |