Sorting formulated cells

[Kurt]

Im trying to produce a spreadsheet with a master
worksheet, linked to 3 sub master worksheets, which in
turn are linked to 3 worksheets each. Basically, I`m
putting data into these worksheets which correlate into
the 3 sub master sheets which in turn correlate into the
master sheet. This works fine with the initial people
listed, but the problem lies when I come to add new people
to my master sheet. When I sort the data to get all the
people in alphabetical order, the sort works but the cells
with fomulas in remain where they are, consequently
putting all my figures out. Can anyone tell me how to sort
the master worksheet after adding info on new lines,
making sure that the formulated cells move also.
Yours frustrated
Kurt

 

[Paul]

Im trying to produce a spreadsheet with a master
worksheet, linked to 3 sub master worksheets, which in
turn are linked to 3 worksheets each. Basically, I`m
putting data into these worksheets which correlate into
the 3 sub master sheets which in turn correlate into the
master sheet. This works fine with the initial people
listed, but the problem lies when I come to add new people
to my master sheet. When I sort the data to get all the
people in alphabetical order, the sort works but the cells
with fomulas in remain where they are, consequently
putting all my figures out. Can anyone tell me how to sort
the master worksheet after adding info on new lines,
making sure that the formulated cells move also.
Yours frustrated
Kurt

When sorting in Excel, it's always best to select the area you want to sort
first, before doing the sort. That way, you can be sure what will be
included in the sort.

If you don't select a range first, Excel will attempt to define the range
itself. Basically it starts from the active cell and includes adjacent rows
and columns containing data. However, I wouldn't trust it to get this right!

If you do select a range first, whatever is selected will be sorted but
anything not selected will be left where it is. Of course, if you wish you
can select the whole worksheet - by clicking the grey square at the
intersection of row numbers and column letters.