Linked Cells on Separate Worksheets

  • Thread starter Visual Calendar Dilemma
  • Start date
V

Visual Calendar Dilemma

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?
 
Top