Automatically refresh sorted data
 

How do I set up the same set of data to re-sort every time the source data
changes? My data is pulled from another sheet within the file. When this data
changes, I want the sorted data in the final sheet to reflect the new numbers
without having to manually resort the final sheet every time.

Thanks!

Automatically refresh sorted data
 

hi
how are you refreshing the data? if by macro, you can add code to the end to
resosrt.

regards
FSt1

"Cardian" wrote:

How do I set up the same set of data to re-sort every time the source data
changes? My data is pulled from another sheet within the file. When this data
changes, I want the sorted data in the final sheet to reflect the new numbers
without having to manually resort the final sheet every time.

Thanks!

Automatically refresh sorted data
 

I'm sorting the long, old-fashioned way. I used to create macros in Excel 15
years ago and need to get up to speed on my 2007 version. I am copying the
data to a new sheet each time the original data from the web refreshes
(daily), then deleting unnecessary columns, then sorting by the column I
want. Any suggestions would be greatly appreciated......Thanks!

"FSt1" wrote:

hi
how are you refreshing the data? if by macro, you can add code to the end to
resosrt.

regards
FSt1

"Cardian" wrote:

How do I set up the same set of data to re-sort every time the source data
changes? My data is pulled from another sheet within the file. When this data
changes, I want the sorted data in the final sheet to reflect the new numbers
without having to manually resort the final sheet every time.

Thanks!

Automatically refresh sorted data
 

All of this should be able to be done with ONE mouse click. Or, even
automatically if your fetch is on a timer.
1. Define the data to copy to the new sheet (Perhaps you don't have to copy
it if you can HIDE the columns desired on your fetch sheet).
2. Decide where it is to be copied
3. Delete the columns
4. Sort
If all else fails, send me a workbook to the address BELOW
--
Don Guillett
Microsoft MVP Excel
SalesAid Software


"Cardian" wrote in message
...
I'm sorting the long, old-fashioned way. I used to create macros in Excel
15
years ago and need to get up to speed on my 2007 version. I am copying the
data to a new sheet each time the original data from the web refreshes
(daily), then deleting unnecessary columns, then sorting by the column I
want. Any suggestions would be greatly appreciated......Thanks!

"FSt1" wrote:

hi
how are you refreshing the data? if by macro, you can add code to the end
to
resosrt.

regards
FSt1

"Cardian" wrote:

How do I set up the same set of data to re-sort every time the source
data
changes? My data is pulled from another sheet within the file. When
this data
changes, I want the sorted data in the final sheet to reflect the new
numbers
without having to manually resort the final sheet every time.

Thanks!

Automatically refresh sorted data
 

Cardian

You can also link the cells in your new sheet with absolute references to
the original data.
This means the data will change simultaneously.
Now in your new sheet toolsmacrorecord.
Assign a shortkey eg cntrl+k in the dialogue box and make sure the macro is
in the workbook not w/sheet.
in record mode higlight relevant cells, sort to your liking and stop macro.

"Don Guillett" wrote:

All of this should be able to be done with ONE mouse click. Or, even
automatically if your fetch is on a timer.
1. Define the data to copy to the new sheet (Perhaps you don't have to copy
it if you can HIDE the columns desired on your fetch sheet).
2. Decide where it is to be copied
3. Delete the columns
4. Sort
If all else fails, send me a workbook to the address BELOW
--
Don Guillett
Microsoft MVP Excel
SalesAid Software


"Cardian" wrote in message
...
I'm sorting the long, old-fashioned way. I used to create macros in Excel
15
years ago and need to get up to speed on my 2007 version. I am copying the
data to a new sheet each time the original data from the web refreshes
(daily), then deleting unnecessary columns, then sorting by the column I
want. Any suggestions would be greatly appreciated......Thanks!

"FSt1" wrote:

hi
how are you refreshing the data? if by macro, you can add code to the end
to
resosrt.

regards
FSt1

"Cardian" wrote:

How do I set up the same set of data to re-sort every time the source
data
changes? My data is pulled from another sheet within the file. When
this data
changes, I want the sorted data in the final sheet to reflect the new
numbers
without having to manually resort the final sheet every time.

Thanks!