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
--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany

"dansargeant >" <<(E-Mail Removed)> schrieb im
Newsbeitrag news:(E-Mail Removed)...
> I have numeric data that is entered on sheet 1 and is linked to
sheet
> 2. The purpose of sheet 2 is to list doners with their gift amounts
in
> decending order. It works ok except that I have to manually sort.
Is
> there a way to have the data on sheet 2 automatically sort
accordingly
> as numbers change on sheet 1?
>
> Attachment filename: drive 2004.xls
> Download attachment:
http://www.excelforum.com/attachment.php?postid=665864
> ---
> Message posted from http://www.ExcelForum.com/
>

See
http://www.bplumhoff.de/software/eff...y_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