Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Linked Cells on Separate Worksheets

I have two worksheets. One worksheet is my "template" and the other is a
worksheet that I have cells linked to cells in my template.

I would like to sort my "template" worksheet while keeping my cells linked
correctly in my second worksheet.

Example:
Worksheet Template.
Column A
Hat
Dog
Cat
Coat

Worksheet #2 - Linked to the above
Hat
Dog
Cat
Coat

I want to sort Worksheet Template Alphabetically
Cat
Coat
Dog
Hat

But I want Worksheet #2 to stay in the below order:
Hat
Dog
Cat
Coat

Is this possible?



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
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Linked cells from ActiveX control kenn74 Excel Worksheet Functions 0 March 6th 06 06:20 PM
Separate first and second name in one cell into separate cells. Dwight in Georgia Excel Discussion (Misc queries) 3 January 25th 06 09:09 PM
Separate first and second name in one cell into separate cells. Gary's Student Excel Discussion (Misc queries) 0 April 27th 05 11:11 PM


All times are GMT +1. The time now is 03:02 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"