Keeping the same info from another workbook after sorting

[shaftdx]

Good Morning all,

I am sure there is an easy way to do this but it escapes me. I have 2 worksheets in 2 different tabs in the same file Named FLEET and Service Work. The Fleet sheet is constantly getting resorted based on the different criteria I need at the time. (Ie Numerically, the year it retires or if it is an active bus.) On the Service work tab I have a list of the same buses sorted numerically. The the problem is when I sort the Fleet sheet some info gets sorted on the service work tab because I linked some info from the fleet sheet. so now all of a sudden one of the buses on the Service work sheet says it is sold instead of active. Is there a way I can keep those linked cells to stay with the corresponding bus on the fleet sheet no matter where it is on the column when it gets sorted?

 

[Marc L]

Hi,​

​

an easy way is to name cells and using the named cells rather than an address …​