Google spreadsheet analytics automatically sorting

Question

I have a Google Spreadsheet issue, I have an analytics sheet (sheet A) with url entries.

The data from that sheet (sheet A) is stored in a different sheet (sheet B) Now I want to the URLS + NUMBERS automatically sorted on the numbers in sheet B.

I have extracted them with success, but I can't use the spreadsheet sort option because the data is generated and changes every day which means the sort option resets when it recieves new info.

I've tried this query :

=QUERY(a:b , "SELECT * ORDER BY b") 

I've looked for a Google script but I have 3 columns:

Entry | Exit | General

• Sheet A

  

• Sheet B

  

• Sheet B, after View > All formulas

  

Answer 1

Based on your screenshots you want the sorted data to be in Total Results D12:E and your original data is in Landing oud!A16:B.

In order to do that, delete everything in range Total Results D12:E. Then, in cell Total Results D12 enter the following formula

=QUERY('Landing oud'!A16:B , "SELECT * ORDER BY B")