saracat2012
New Member
- Joined
- Jun 27, 2023
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hello again all. My brain hurts trying to figure out this one. I have a spreadsheet of all open orders, listed by date. I'm trying to find the last instance of a workday date, insert a row, format the row, and add text to the first cell. I can get the formatting part pretty easily, the tricky bit is finding the last instance of the workday and inserting the row. Attached is a before and after shot of what I'm trying to do. (I already have a macro that conditionally formats based on today's date and the workday function color in the dates.)
cards.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Product | |||
2 | 7/1/2023 | Prod 1 | |||
3 | 7/5/2023 | Prod 2 | |||
4 | 7/20/2023 | Prod 5 | |||
5 | 7/21/2023 | Prod 3 | |||
6 | 7/24/2023 | Prod 7 | |||
7 | 7/24/2023 | Prod 4 | |||
8 | 7/25/2023 | Prod 8 | |||
9 | 7/26/2023 | Prod 100 | |||
10 | 7/26/2023 | Prod 10 | |||
11 | 7/27/2023 | Prod 42 | |||
12 | 7/28/2023 | Prod 937 | |||
13 | 7/31/2023 | ||||
14 | 8/1/2023 | ||||
15 | |||||
16 | Date | Product | |||
17 | 7/1/2023 | Prod 1 | |||
18 | 7/5/2023 | Prod 2 | |||
19 | 7/20/2023 | Prod 5 | |||
20 | 7/21/2023 | Prod 3 | |||
21 | Due Today/Overdue | ||||
22 | 7/24/2023 | Prod 7 | |||
23 | 7/24/2023 | Prod 4 | |||
24 | Day 1 | ||||
25 | 7/25/2023 | Prod 8 | |||
26 | Day 2 | ||||
27 | 7/26/2023 | Prod 100 | |||
28 | 7/26/2023 | Prod 10 | |||
29 | Day 3 | ||||
30 | 7/27/2023 | Prod 42 | |||
31 | Day 4 | ||||
32 | 7/28/2023 | Prod 937 | |||
33 | Day 5 | ||||
34 | 7/31/2023 | ||||
35 | 8/1/2023 | ||||
Sheet2 |