Linking Data in different workbooks and then sorting
Hi
I have column A of workbook B linking to data in workbook A; then column B of workbook B has independent data values. When I sort workbook A the data points move in workbook B; and then columns A and B in workbook B become out of sync.
Is there any solution to this problem?
Thanks!
|