eastrand
Board Regular
- Joined
- Nov 27, 2013
- Messages
- 101
- Office Version
- 365
- Platform
- Windows
I have a data set similar to the one below. In VBA, how do I find the first row and the last row in between two dates. In this example, between 01/10/2022 - 01/14/2022
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Product | Qty | Sales | ||
2 | 1/3/2022 | Prod3 | 16 | $ 70.72 | ||
3 | 1/3/2022 | Prod1 | 24 | $ 106.08 | ||
4 | 1/3/2022 | Prod2 | 19 | $ 83.98 | ||
5 | 1/3/2022 | Prod2 | 14 | $ 61.88 | ||
6 | 1/4/2022 | Prod2 | 18 | $ 79.56 | ||
7 | 1/4/2022 | Prod3 | 23 | $ 101.66 | ||
8 | 1/4/2022 | Prod1 | 16 | $ 70.72 | ||
9 | 1/10/2022 | Prod2 | 18 | $ 79.56 | ||
10 | 1/10/2022 | Prod3 | 23 | $ 101.66 | ||
11 | 1/10/2022 | Prod2 | 23 | $ 101.66 | ||
12 | 1/10/2022 | Prod3 | 10 | $ 44.20 | ||
13 | 1/11/2022 | Prod3 | 21 | $ 92.82 | ||
14 | 1/11/2022 | Prod1 | 7 | $ 30.94 | ||
15 | 1/11/2022 | Prod1 | 23 | $ 101.66 | ||
16 | 1/11/2022 | Prod3 | 7 | $ 30.94 | ||
17 | 1/12/2022 | Prod1 | 20 | $ 88.40 | ||
18 | 1/12/2022 | Prod1 | 14 | $ 62.22 | ||
19 | 1/13/2022 | Prod2 | 14 | $ 59.99 | ||
20 | 1/13/2022 | Prod3 | 13 | $ 57.75 | ||
21 | 1/14/2022 | Prod1 | 13 | $ 55.52 | ||
22 | 1/14/2022 | Prod2 | 12 | $ 53.28 | ||
23 | 1/15/2022 | Prod3 | 12 | $ 51.05 | ||
24 | 1/15/2022 | Prod2 | 11 | $ 48.81 | ||
25 | 1/16/2022 | Prod3 | 11 | $ 46.58 | ||
26 | 1/16/2022 | Prod3 | 10 | $ 44.35 | ||
27 | 1/17/2022 | Prod1 | 10 | $ 42.11 | ||
Sheet1 |