LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated Data Summary Worksheet kimmy8240 Excel Discussion (Misc queries) 0 July 31st 09 01:41 AM
Moving data from one worksheet to another in automated, linked, or BruceLoe Excel Discussion (Misc queries) 3 June 1st 08 05:27 PM
Need help with refreshing data Cam Excel Discussion (Misc queries) 0 April 15th 08 07:12 PM
How to turn off the automated dates in excel (when importing data) Sanna Excel Discussion (Misc queries) 2 July 4th 07 01:04 PM
Refreshing external data breaks sorting of function columns BNick Excel Discussion (Misc queries) 0 October 2nd 06 06:46 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"