I am using the below to extract data and it is working. I would like to modify slightly to get data between a certain date a time instead of the range.
Workbooks("SOURCE").Worksheets("Sheet1").Range("D:D").Copy Destination:=Workbooks("DESTINATION").Worksheets("sheet1").Range("IN:IN")
I need to extract the Value in column B when the time in column A is 00:00:00 (22/07/2023) and 23:00:00 (22/07/2023)
A B
Workbooks("SOURCE").Worksheets("Sheet1").Range("D:D").Copy Destination:=Workbooks("DESTINATION").Worksheets("sheet1").Range("IN:IN")
I need to extract the Value in column B when the time in column A is 00:00:00 (22/07/2023) and 23:00:00 (22/07/2023)
A B
Time | Value |
18:00:00 (21/07/2023) | 9033883.647 |
19:00:00 (21/07/2023) | 9033883.647 |
20:00:00 (21/07/2023) | 9033883.647 |
21:00:00 (21/07/2023) | 9033883.647 |
22:00:00 (21/07/2023) | 9033883.647 |
23:00:00 (21/07/2023) | 9033883.647 |
00:00:00 (22/07/2023) | 9033883.647 |
01:00:00 (22/07/2023) | 9033883.647 |
02:00:00 (22/07/2023) | 9033883.647 |
03:00:00 (22/07/2023) | 9033883.647 |
04:00:00 (22/07/2023) | 9033883.647 |
05:00:00 (22/07/2023) | 9033883.647 |
06:00:00 (22/07/2023) | 9033883.647 |
07:00:00 (22/07/2023) | 9033883.647 |
08:00:00 (22/07/2023) | 9033883.647 |
09:00:00 (22/07/2023) | 9033883.647 |
10:00:00 (22/07/2023) | 9033883.647 |
11:00:00 (22/07/2023) | 9033883.647 |
12:00:00 (22/07/2023) | 9033883.647 |
13:00:00 (22/07/2023) | 9033883.647 |
14:00:00 (22/07/2023) | 9033883.647 |
15:00:00 (22/07/2023) | 9033883.647 |
16:00:00 (22/07/2023) | 9033883.648 |
17:00:00 (22/07/2023) | 9033883.648 |
18:00:00 (22/07/2023) | 9033883.648 |
19:00:00 (22/07/2023) | 9033883.648 |
20:00:00 (22/07/2023) | 9033883.648 |
21:00:00 (22/07/2023) | 9033883.648 |
22:00:00 (22/07/2023) | 9033883.648 |
23:00:00 (22/07/2023) | 9033883.648 |
00:00:00 (23/07/2023) | 9033883.648 |
01:00:00 (23/07/2023) | 9033883.648 |
02:00:00 (23/07/2023) | 9033883.648 |
03:00:00 (23/07/2023) | 9033883.648 |
04:00:00 (23/07/2023) | 9033883.648 |
05:00:00 (23/07/2023) | 9033883.648 |