Linking Worksheets in Excel

[kunalb33]

Been assigned a project @ work and havent been able to fig it out for days now.
someone help

I have an excel file which contains a large list that consists of 3 types of customers
A
B
C

I have another spreadsheet which I have linked each A type customer to.

I am trying to sort the first spreadsheet and have the second linked spreadsheet update as I sort.
The sorting works just fine but the second file keeps the same links and does not move as I would like.

if row 1 on File B is linked to row 30 on File A
After sorting it still references row 30 .
But I want it to reference the old value that used to be on row 30 but now has moved to row 45 after sorting.

I know I havent explained this too well...but any input is appreciated.

Thanxs.

[AlfD]

Hi!

See your other post .

Alf