Sorting Data in a Linked Workbook

[renato1]

Hi;

I am having some problems and would really appreciate any help

I have column A of workbook B linking to data in column A of workbook A; then column B of workbook B has independent data values. When I sort column A of workbook A the data points move in workbook B; and then columns A and B in workbook B become out of sync.

Is the there any way of solving this issue?

Thanks

 

[renato1]

Is there any solution to the problem above?

Thanks