Before you sort, you need to convert the formula to a value.
You can do this manually by using copy and then perform a
 paste-special right back to the same cell.

A Macro or VBA code module would allow you to automate the entire
process from entering the employee information all the way through
to sorting the final list.

Jim Meagher
=====
Micro Solutions Consulting        Member of The HTML Writers Guild
http://www.ezy.net/~microsol     International Webmasters Association
410-543-8996                MS Site Builder Network - Level 2 member
=====
----- Original Message -----
From: Jacobs, Laurie <[log in to unmask]>

> Hello all you Excel experts,
>
> In Excel 97 I've got a list of people and their pay.
> A new person is added to the list who earns an aveage of the other peoples
> pay
> The list might then need to be sorted by name or by pay.
> How can I make the formula for calculating the aveage pay still work when
> the order has been changed and the new persons position in the list
changes
> ?
> I get a circular reference after I do the sorting.

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                     http://nospin.com/pc/files.html