Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORTING AFTER AUTOMATED REFRESHING OF DATA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORTING AFTER AUTOMATED REFRESHING OF DATA
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 "Ruud van Deursen" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SORTING AFTER AUTOMATED REFRESHING OF DATA
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 appear. the sort criterial in on the third sheet. -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated Data Summary Worksheet | Excel Discussion (Misc queries) | |||
Moving data from one worksheet to another in automated, linked, or | Excel Discussion (Misc queries) | |||
Need help with refreshing data | Excel Discussion (Misc queries) | |||
How to turn off the automated dates in excel (when importing data) | Excel Discussion (Misc queries) | |||
Refreshing external data breaks sorting of function columns | Excel Discussion (Misc queries) |