I have a sheet by name "Headers" and the range from AA2 to AA25 so need to check from this list if any of the missing records found in sheet "FinalReport" from B4 to B28 and if found the vba will insert a row
eg:- now missing record for 5 so now the script will search 4 in FinalReport and then will insert a row after it find the 4 and after insert it i will do the average of 3 & 4
any way to do this. it is taking around 2 hr to do the task manually now.
eg:- now missing record for 5 so now the script will search 4 in FinalReport and then will insert a row after it find the 4 and after insert it i will do the average of 3 & 4
any way to do this. it is taking around 2 hr to do the task manually now.
CST_NW_District_Automation_V1.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
4 | 2024-10-08 | 7.00 | 99.35 | 99.74 | 100.00 | 99.21 | 100.00 | 100.00 | 100.00 | 99.40 | 100.00 | 94.98 | N/A | ||
5 | 2024-10-08 | 8.00 | 99.35 | 99.81 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
6 | 2024-10-08 | 9.00 | 99.26 | 99.71 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
7 | 2024-10-08 | 10.00 | 99.31 | 99.67 | 100.00 | 97.59 | 100.00 | 99.92 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
8 | 2024-10-08 | 11.00 | 99.35 | 99.76 | 100.00 | 98.56 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
9 | 2024-10-08 | 12.00 | 99.35 | 99.77 | 100.00 | 98.78 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
10 | 2024-10-08 | 13.00 | 99.35 | 99.82 | 100.00 | 98.79 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
11 | 2024-10-08 | 14.00 | 99.35 | 99.82 | 100.00 | 98.62 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
12 | 2024-10-08 | 15.00 | 99.35 | 99.83 | 100.00 | 99.20 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
13 | 2024-10-08 | 16.00 | 99.35 | 99.82 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
14 | 2024-10-08 | 17.00 | 99.45 | 99.83 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
15 | 2024-10-08 | 18.00 | 99.45 | 99.82 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
16 | 2024-10-08 | 19.00 | 99.45 | 99.81 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
17 | 2024-10-08 | 20.00 | 99.45 | 99.80 | 100.00 | 99.13 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
18 | 2024-10-08 | 21.00 | 99.45 | 99.73 | 100.00 | 98.20 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
19 | 2024-10-08 | 22.00 | 99.45 | 99.61 | 100.00 | 98.09 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
20 | 2024-10-08 | 23.00 | 99.45 | 98.76 | 100.00 | 92.42 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
21 | 2024-10-09 | 0.00 | 99.45 | 98.77 | 100.00 | 92.45 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
22 | 2024-10-09 | 1.00 | 99.45 | 98.77 | 100.00 | 92.45 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
23 | 2024-10-09 | 2.00 | 99.45 | 98.85 | 100.00 | 92.98 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
24 | 2024-10-09 | 3.00 | 99.36 | 99.83 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
25 | 2024-10-09 | 4.00 | 99.35 | 99.84 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
26 | 2024-10-09 | 6.00 | 99.35 | 99.71 | 100.00 | 99.23 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | N/A | ||
FinalReport |
CST_NW_District_Automation_V1.xlsm | |||
---|---|---|---|
AA | |||
2 | 0.00 | ||
3 | 1.00 | ||
4 | 2.00 | ||
5 | 3.00 | ||
6 | 4.00 | ||
7 | 5.00 | ||
8 | 6.00 | ||
9 | 7.00 | ||
10 | 8.00 | ||
11 | 9.00 | ||
12 | 10.00 | ||
13 | 11.00 | ||
14 | 12.00 | ||
15 | 13.00 | ||
16 | 14.00 | ||
17 | 15.00 | ||
18 | 16.00 | ||
19 | 17.00 | ||
20 | 18.00 | ||
21 | 19.00 | ||
22 | 20.00 | ||
23 | 21.00 | ||
24 | 22.00 | ||
25 | 23.00 | ||
Headers |