how "i-tunes" your spreadsheet?

[andrew1981]

Hello fellow excel users,

I am trying to figure out how to make your spread sheet have some o
the sorting features such as in I-tunes. For example, I would like t
be to able name my collums in different catogories. (ex: year, son
name, artist), and then be able to click on this collum title to hav
the data posted in alphebetical or numerical order. I am having
problem doing this. Can someone please help me?
Is it possible with excel? Or should I be trying to use access for thi
kind of project?

Thanks alot,

Andrew:

 

[broro183]

Hi Andrew,
yes, it is definitely possible but if you have a lot of music you may
want to try using a Pivot table approach in Excel (check out help files
& post any questions you have) or moving into Access(probably not
necessary).

For some possible techniques check out the links included in the thread
listed below:
http://excelforum.com/showthread.php?t=512169&highlight=sort+double+click

Hth,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[Dave Peterson]

Debra Dalgleish has a way:
http://contextures.com/xlSort02.html