Keeping cell info intact when sorting worksheets w/some linked cel

J

judie

I should clarify something re my question below, which was: I have a source
worksheet from which I've linked several other worksheets. If I alpha sort
the source worksheet, the sort results are fine -- has column-for-column,
row-for-row integrity -- all information in rows stays together with the
individual's NAME, which is what is sorted. However, if I sort any worksheet
that's linked to my primary worksheet, and I alpha sort the NAMES column, the
information from cells in other columns of that row do not sort with it.

CLARIFIED: In the secondary worksheets, some cells of columns are linked and
some are not. The ones that are linked sort; the cells each row that are not
linked to the primary worksheet do not sort.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top