cells lose relativity to other WorkSheets after data sort?
 

two worksheets in same workbook. Cells in one WS use formula to pull data
from 2nd WS. If 2nd WS data is sorted, the first WS loses relativity and the
data changes.

Hi
if the source is sorted the cell references do nOT move with the former
entry but still remain linked to the cell position. No way to change
this. If you have a unique ID in your source table you may consider
using vLOOKUP for this:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany


Ed Murray - ALPCO wrote:
two worksheets in same workbook. Cells in one WS use formula to pull
data from 2nd WS. If 2nd WS data is sorted, the first WS loses
relativity and the data changes.