View Single Post
  #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