Sorting a list

[martialtiger]

Hi Everyone,

I'm using Excel 2003 and I have a question regarding a solution t
sorting data when you click on a certain cell. Let's say the 1st ro
contains my headers and the 1st column contains company names. So ro
1 shows number of goods sold, average daily sales, total revenue, etc
and column A contains company 1, company 2, company 3, etc... Is ther
a way I insert a code or macro to where if I were to click on the cel
containing total revenue, the sheet would automatically sort from leas
to greatest while maintaining integrity throughout the companies and i
i were to click it again it would go into descending order?

I hope this makes sense.

TIA :confused

 

[Arvi Laanemets]

Hi

It looks like you want to sort columnwise. In Sort window click on Options
button and select 'Sort left to right'. In Sort window, estimate the row you
are sorting at, and there you are!