Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 3
Default Keeping cell info intact when sorting worksheets w/some linked cel

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keeping rows together during column sorts of linked worksheets judie Excel Worksheet Functions 1 April 1st 07 07:52 PM
Sorting columns while keeping row data intact Paul New Users to Excel 5 February 21st 07 04:41 PM
Keeping formula format intact Michael Excel Discussion (Misc queries) 1 November 24th 06 03:25 PM
Keeping the same format in linked worksheets Confused Excel Worksheet Functions 1 August 3rd 06 01:49 PM
keeping rows intact during sort Jim Excel Discussion (Misc queries) 2 November 25th 05 01:59 AM


All times are GMT +1. The time now is 01:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"