Remove Negative Values and Sort Data Range without affecting formulas

[Reevu]

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:

[TABLE="width: 368"]
<tbody>[TR]
[TD="colspan: 2"]Current[/TD]
[TD][/TD]
[TD="colspan: 2"]Expected[/TD]
[/TR]
[TR]
[TD]VRID[/TD]
[TD]Delay[/TD]
[TD]VRID[/TD]
[TD]Delay[/TD]
[/TR]
[TR]
[TD]115BS9VTJ[/TD]
[TD="align: right"]0:38[/TD]
[TD]1133SG4BV[/TD]
[TD="align: right"]23:38[/TD]
[/TR]
[TR]
[TD]1133SG4BV[/TD]
[TD="align: right"]23:38[/TD]
[TD]114XDQ2PL[/TD]
[TD="align: right"]22:08[/TD]
[/TR]
[TR]
[TD]114XDQ2PL[/TD]
[TD="align: right"]22:08[/TD]
[TD]114RHWGM2[/TD]
[TD="align: right"]4:58[/TD]
[/TR]
[TR]
[TD]115SDZ4YY[/TD]
[TD="align: right"]-0:04[/TD]
[TD]1116P4ZC6[/TD]
[TD="align: right"]3:59[/TD]
[/TR]
[TR]
[TD]113G6JDHL[/TD]
[TD="align: right"]0:33[/TD]
[TD]112YHRFFP[/TD]
[TD="align: right"]2:54[/TD]
[/TR]
[TR]
[TD]115GYS683[/TD]
[TD="align: right"]1:29[/TD]
[TD]116TBSG79[/TD]
[TD="align: right"]2:42[/TD]
[/TR]
[TR]
[TD]114RHWGM2[/TD]
[TD="align: right"]4:58[/TD]
[TD]114FS77L9[/TD]
[TD="align: right"]1:52[/TD]
[/TR]
[TR]
[TD]116KMBFH7[/TD]
[TD="align: right"]1:08[/TD]
[TD]1141R2NNB[/TD]
[TD="align: right"]1:49[/TD]
[/TR]
[TR]
[TD]116TBSG79[/TD]
[TD="align: right"]2:42[/TD]
[TD]1137C318J[/TD]
[TD="align: right"]1:32[/TD]
[/TR]
[TR]
[TD]1145J8QFL[/TD]
[TD="align: right"]-0:36[/TD]
[TD]115GYS683[/TD]
[TD="align: right"]1:29[/TD]
[/TR]
[TR]
[TD]11231KFDN[/TD]
[TD="align: right"]1:23[/TD]
[TD]114C36VC7[/TD]
[TD="align: right"]1:28[/TD]
[/TR]
[TR]
[TD]112DPTRGB[/TD]
[TD="align: right"]-2:07[/TD]
[TD]11231KFDN[/TD]
[TD="align: right"]1:23[/TD]
[/TR]
[TR]
[TD]114FS77L9[/TD]
[TD="align: right"]1:52[/TD]
[TD]113D2N6MF[/TD]
[TD="align: right"]1:13[/TD]
[/TR]
[TR]
[TD]115YXS1JP[/TD]
[TD="align: right"]-0:36[/TD]
[TD]113514BWX[/TD]
[TD="align: right"]1:10[/TD]
[/TR]
[TR]
[TD]1137C318J[/TD]
[TD="align: right"]1:32[/TD]
[TD]116KMBFH7[/TD]
[TD="align: right"]1:08[/TD]
[/TR]
[TR]
[TD]114L3LHYM[/TD]
[TD="align: right"]-0:12[/TD]
[TD]1128X3Q1F[/TD]
[TD="align: right"]1:02[/TD]
[/TR]
[TR]
[TD]1141R2NNB[/TD]
[TD="align: right"]1:49[/TD]
[TD]115BS9VTJ[/TD]
[TD="align: right"]0:38[/TD]
[/TR]
[TR]
[TD]113514BWX[/TD]
[TD="align: right"]1:10[/TD]
[TD]113G6JDHL[/TD]
[TD="align: right"]0:33[/TD]
[/TR]
[TR]
[TD]1116P4ZC6[/TD]
[TD="align: right"]3:59[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]114C36VC7[/TD]
[TD="align: right"]1:28[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]113D2N6MF[/TD]
[TD="align: right"]1:13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1128X3Q1F[/TD]
[TD="align: right"]1:02[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]112YHRFFP[/TD]
[TD="align: right"]2:54[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]114YZGTQ9[/TD]
[TD="align: right"]-0:17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Appreciate any ideas / assistance. Thanks a ton!