LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Becks
 
Posts: n/a
Default Problem created by sorting linked sheet

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
 
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
Excell Problem when opening file created in another application!! Zircum Excel Discussion (Misc queries) 2 March 28th 06 03:31 PM
sorting master sheet messes up cells in other sheets linked to it Kt Excel Worksheet Functions 1 October 30th 05 12:25 PM
Realtime Automatic sorting of data in rows in new work sheet Gazzali Excel Worksheet Functions 0 June 23rd 05 09:35 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM


All times are GMT +1. The time now is 02:57 PM.

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

About Us

"It's about Microsoft Excel"