Sorting

  • Thread starter Thread starter Sherry
  • Start date Start date
S

Sherry

I have asked this question before with no response. I have
an Excel workbook with multiple worksheets. On the first
worksheet, I have entries (names) that are linked to the
subsequent worksheets. Each worksheet contains different
data related to those names. However, if sort the names
on the first sheet, and they sort on the subsequent
sheets, the data out to the side of the names doesn't
sort. This is logical, but what I'm trying to do is find a
way to make a sort of this kind possible. Does anybody
have any ideas? Please contact me at the above email
address if you can help. Thank you.
 
Hi Sherry!

You'll get better responses with a tad more detail on the subject
line. But you're not anywhere near as bad as some who just put "Help"
on the subject line.

You second sheet names appear to be linked by formula to the first
sheet names but the other data is not.

When you sort the first sheet on names selecting the whole table then
the formula link on the second sheet is ensuring a sorting on the
second sheet but only of the names.

You could similarly link the data against each name to the data on the
first sheet. That way a sort of the first sheet data will result in a
sort of the second sheet data.

As a matter of spreadsheet construction I prefer to have a single data
entry sheet and link all other sheets to that data. It saves double
entry error. It's "expensive" in terms of formulas but it does allow
changes of base data and sorting. If you rule out this approach, then
you are just going to have to remember to do a double sort using the
same criteria.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top