View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mandy Mandy is offline
external usenet poster
 
Posts: 55
Default Can I sort data used in formulas on a different workbook?

I need to link values/data from one workbook to another, then sort the
original workbook. I can create an = function but once I sort the first
workbook, that value changes. Can I create a funtion that allows the value
to stay with that line item regardless of how I sort it?