LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
papabear0207
 
Posts: n/a
Default link cell in 1 wk-sht to another & keep it regardless of sorting

I am trying to link a cell ( an item price) in 1 worksheet to another
worksheet and have the correct price displayed regardless of any sorting of
data that I do. When I set up a link it works well except when I sort the
data in the worksheet 1 or 2
 
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
How to link cell for value in another cell of pivot table? JamesChoi Excel Discussion (Misc queries) 1 September 15th 05 03:24 AM
Excel: Format Control: 'cell link' reamins constant. How to copy Rodway N Excel Worksheet Functions 0 September 7th 05 06:21 PM
How do I use a cell value as the filename in an external link? wattkisson Excel Discussion (Misc queries) 5 July 11th 05 09:07 PM
How do I use a cell value as the filename in an external link? wattkisson Excel Worksheet Functions 1 July 8th 05 11:51 PM
Link - deactivate being sent to source when click on linked cell? snidely Excel Worksheet Functions 1 January 11th 05 02:11 AM


All times are GMT +1. The time now is 11:25 AM.

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"