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 |
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 |
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 . |
All times are GMT +1. The time now is 09:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com