Automatic sorting of data

[dansargeant]

I have numeric data that is entered on sheet 1 and is linked to shee
2. The purpose of sheet 2 is to list doners with their gift amounts i
decending order. It works ok except that I have to manually sort. I
there a way to have the data on sheet 2 automatically sort accordingl
as numbers change on sheet 1

Attachment filename: drive 2004.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66586

 

[Frank Kabel]

Hi
possibole but only using VBA (an event procedure). Would this be a
feasible solutuion for you?

 

[Bernd]

See
http://www.bplumhoff.de/software/efficiency_analysis.xls

I think you can use this scheme with two files (both open,
automatic calculation enabled).

Disclaimer: Use at your own risk. I tested it and I have
(I think) no viruses on my computer but ... you never know.

HTH,
Bernd