cells don't adjust
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.... |
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.... |
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 "boraguru" wrote in message ... |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.... |
All times are GMT +1. The time now is 04:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com