Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Sorting linked worksheets

I'm using a massive workbook with multiple linked worksheets. Unfortunately,
when I sort one of the 'master' worksheets, my links are scrambled because
they follow the cell rather than the data.

To illuminate the issue, I have separate 'master' worksheets for
"capabilities" and for "enablers" - these are linked in subsequent worksheets
using the ='Enabler Definitions'!Bxx function.

Is there a simple way of curing this problem?
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 cell info intact when sorting worksheets w/some linked cel judie Setting up and Configuration of Excel 0 April 1st 07 10:12 PM
sorting linked columns across worksheets, maintaing row integrity tam25 Excel Discussion (Misc queries) 0 January 4th 07 12:01 AM
sorting data linked to another workbook Heather Excel Discussion (Misc queries) 0 November 1st 06 06:47 PM
sorting with linked worksheets sbrimley Excel Discussion (Misc queries) 1 April 11th 06 09:37 PM
sorting data in linked worksheets Allyson Excel Discussion (Misc queries) 0 June 8th 05 11:25 PM


All times are GMT +1. The time now is 03:46 PM.

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"