Sorting data problem

[Manos]

Dear all
I have a sheet where i retrieve data from a database
in another sheet i have links to the first sheet where i brink the data from
the database in more formal format and grouping the companies by division
In this sheet i have four columns
first the nmae of the companie, the second ithe last year income the third
is the budget and the forth is the actual income
I would like to sort the data by the forth column in asceding way

I tried to do it but there was a problem with the link and in the other
hand when i was asking the asceding way the was sort only by the fourth
column and there was no change in the other 3 columns, in order to confuse
the data

There is anyway that the sorting could by the 4 column and not confuse the
data?
And each time i trieve the data from the database the sorting could be
automatically without i have to going to teh sheet and do ti manually?

The excel is XP version
Thanks in advance
Manos

 

[Robert Rosenberg]

No way to automatically sort the linked data each time theraw dta is updated
without using a macro.

As for your sorting problem, don't select the column you want to sort by.
Click on any cell within that column's data and use the Sort buttons ont he
toolbar (or the Data-->Sort command).

Note: If there are any blank columns separating the data, you'll need to
select the entire linked data. Once selected, you can use the Tab key to
move the active cell (white cell in selection) across to the 4th column,
then use the sorting buttons OR access the Data-->Sort command.