SORTING AFTER AUTOMATED REFRESHING OF DATA

R

Ruud van Deursen

In Excel i have a query with an automatic refreshrate
from 10 minutes. The data wich is imported in an
excelsheet is coming from a *.txt file.
In excel the data must be sorted al the time in column B.
Everytime after refreshing automatically i have to sort
again manual. Is there a way in VB to handle this also
automaticaly. Now i have a button for it with a macro.

Thank yoy so much
 
M

Mike Fogleman

If the Query is done with VBA then put the sort code at the end of the query
code. If not queried with code, then put your sort code in that worksheet's
code under Private Sub Worksheet_SelectionChange(ByVal Target As Range).
When any cell on that sheet changes value, your sort code will run.
Mike F
 
F

Frank Stone

If you are getting your data through get exteral
data/micorsoft query, there is a sort in mirosoft query.
click any cell inside the query range then on the menu bar
date > get external data >edit query. a wizard will
Click to expand...
appear. the sort criterial in on the third sheet.
 
Top