Remove Negative Values and Sort Data Range without affecting formulas

Reevu

New Member
Joined
Mar 9, 2019
Messages
3
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:

CurrentExpected
VRIDDelayVRIDDelay
115BS9VTJ0:381133SG4BV23:38
1133SG4BV23:38114XDQ2PL22:08
114XDQ2PL22:08114RHWGM24:58
115SDZ4YY-0:041116P4ZC63:59
113G6JDHL0:33112YHRFFP2:54
115GYS6831:29116TBSG792:42
114RHWGM24:58114FS77L91:52
116KMBFH71:081141R2NNB1:49
116TBSG792:421137C318J1:32
1145J8QFL-0:36115GYS6831:29
11231KFDN1:23114C36VC71:28
112DPTRGB-2:0711231KFDN1:23
114FS77L91:52113D2N6MF1:13
115YXS1JP-0:36113514BWX1:10
1137C318J1:32116KMBFH71:08
114L3LHYM-0:121128X3Q1F1:02
1141R2NNB1:49115BS9VTJ0:38
113514BWX1:10113G6JDHL0:33
1116P4ZC63:59
114C36VC71:28
113D2N6MF1:13
1128X3Q1F1:02
112YHRFFP2:54
114YZGTQ9-0:17

<tbody>
</tbody>

Appreciate any ideas / assistance. Thanks a ton!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,214,614
Messages
6,120,517
Members
448,968
Latest member
Ajax40

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top