It's not a good idea to use formulas to refer to items in lists or databases
in Excel. Excel was not designed with this in mind and you're only going to
have problems. When it comes to sorting, each list sorts on its own,
whether on the same worksheet or on another. Creating formula links doesn't
change this. The thing to remember is that a sort switches the data/formats
in cells but it does not switch the cells themselves.
--
Jim
|I figured out what was wrong. But no I have more problems!!!
|
| First I have multiple worksheets in a workbook.
| And in one column that has some names. and the columns next to them has
data
| which is yes/no go/ngo for each person.
| If I add a person it will update itself in each worksheet. But I need to
| sort it.
| So I sort it and it sorts fine in the worksheet I'm working in. But with
| the other worksheets it sorts it but the data for each person doesn't stay
| with the person...
| I hope I explained this problem to where someone can understand. PLEASE
| HELP!!!
|
| "boraguru" wrote:
|
| > In other words the cells to the right of the cells be sorted don't shift
down
| > when I sort the page. If you need meto explain more I can!
| >
| > "boraguru" wrote:
| >
| > > when worksheet is sorted the corresponding cells or the cells linked
to the
| > > right, don't move with them. they stay in the same spot. Also this
is a big
| > > work group with worksheets that are linked and referenced together....
