Problem created by sorting linked sheet

Giganews Newsgroups
Subject: Problem created by sorting linked sheet
Posted by:  Becks
Date: Tue, 2 May 2006

Hi - I have a sheet (Sheet 2), that pulls cells through from another sheet
(Sheet 1) and uses the Uniquevalues function.  I then have unlinked blank
cells that i enter data in seperately, but is info for the names in the
linked cells.  When i use sort on sheet 1, cells A1:A3 move together, i need
A4 to move with them, is this possible?

    Example of Sheet 2
|    Info from sheet 1    |
A1            A2            A3          A4
Name    Ref No        Date    Blank Cell

Thanks

Becks

Replies