Hello!
I have a worksheet that fetches data from a site. (Sheet 1)
Now I have used indirect references with a helper sheet (Sheet 2) to fetch the relevant data to a new sheet (Sheet 3).
In Sheet 3 I have two columns-
Column A - Data Set 1 (Unique IDs)
Column B - Data Set 2 (It is time which can be positive or negative)
Now I need to refresh this every 30 minutes and get either Sheet 3 or a new Sheet 4 to display only the values in Column A (Data Set 1) that correspond to the positive values in Column B (Data Set 2) without disturbing the formulas and without blank or error rows in between. It needs to be refreshed again and repeat the process every 30 minutes.
Sheet 3:
<tbody>
</tbody>
Appreciate any ideas / assistance. Thanks a ton!
I have a worksheet that fetches data from a site. (Sheet 1)
Now I have used indirect references with a helper sheet (Sheet 2) to fetch the relevant data to a new sheet (Sheet 3).
In Sheet 3 I have two columns-
Column A - Data Set 1 (Unique IDs)
Column B - Data Set 2 (It is time which can be positive or negative)
Now I need to refresh this every 30 minutes and get either Sheet 3 or a new Sheet 4 to display only the values in Column A (Data Set 1) that correspond to the positive values in Column B (Data Set 2) without disturbing the formulas and without blank or error rows in between. It needs to be refreshed again and repeat the process every 30 minutes.
Sheet 3:
Current | Expected | ||
VRID | Delay | VRID | Delay |
115BS9VTJ | 0:38 | 1133SG4BV | 23:38 |
1133SG4BV | 23:38 | 114XDQ2PL | 22:08 |
114XDQ2PL | 22:08 | 114RHWGM2 | 4:58 |
115SDZ4YY | -0:04 | 1116P4ZC6 | 3:59 |
113G6JDHL | 0:33 | 112YHRFFP | 2:54 |
115GYS683 | 1:29 | 116TBSG79 | 2:42 |
114RHWGM2 | 4:58 | 114FS77L9 | 1:52 |
116KMBFH7 | 1:08 | 1141R2NNB | 1:49 |
116TBSG79 | 2:42 | 1137C318J | 1:32 |
1145J8QFL | -0:36 | 115GYS683 | 1:29 |
11231KFDN | 1:23 | 114C36VC7 | 1:28 |
112DPTRGB | -2:07 | 11231KFDN | 1:23 |
114FS77L9 | 1:52 | 113D2N6MF | 1:13 |
115YXS1JP | -0:36 | 113514BWX | 1:10 |
1137C318J | 1:32 | 116KMBFH7 | 1:08 |
114L3LHYM | -0:12 | 1128X3Q1F | 1:02 |
1141R2NNB | 1:49 | 115BS9VTJ | 0:38 |
113514BWX | 1:10 | 113G6JDHL | 0:33 |
1116P4ZC6 | 3:59 | ||
114C36VC7 | 1:28 | ||
113D2N6MF | 1:13 | ||
1128X3Q1F | 1:02 | ||
112YHRFFP | 2:54 | ||
114YZGTQ9 | -0:17 |
<tbody>
</tbody>
Appreciate any ideas / assistance. Thanks a ton!