I have a workbook which refers to data across several sheets.

On the setup page names are entered as eg John and Smith
on another page the name is concatenated to become John Smith
later it is referred to as Setup!d5 and then used in a sorted table
from A10 on that sheet. (all very confusing but necessary!)

Is it possible to make the contents of A10 for instance a value as when
the table is sorted with $s the data is taken from Setup d5 and not the
sorted data!!

I hope that someone understands my problem and can offer a fix?

Best wishes from a wet North Yorkshire UK.


Jp