I have a data set similar to the one below. In VBA, how do I find the first row on or after "StartDate" and the last row on or before "EndDate. In this example, on or after 01/10/2022 and on or before 01/14/2022.
Date Product Qty Sales
1/3/2022 Prod3 16 $70.72
1/3/2022 Prod1 24 $106.08
1/3/2022 Prod2 19 $83.98
1/3/2022 Prod2 14 $61.88
1/4/2022 Prod2 18 $79.56
1/4/2022 Prod3 23 $101.66
1/4/2022 Prod1 16 $70.72
1/10/2022 Prod2 18 $79.56
1/10/2022 Prod3 23 $101.66
1/10/2022 Prod2 23 $101.66
1/10/2022 Prod3 10 $44.20
1/11/2022 Prod3 7 $30.94
1/12/2022 Prod1 20 $88.40
1/12/2022 Prod1 14 $62.22
1/13/2022 Prod2 14 $59.99
1/13/2022 Prod3 13 $57.75
1/15/2022 Prod3 12 $51.05
1/15/2022 Prod2 11 $48.81
1/16/2022 Prod3 11 $46.58
1/16/2022 Prod3 10 $44.35
1/17/2022 Prod1 10 $42.11
Bookmarks