ExcelBanter - Sort with Link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sort with Link (https://www.excelbanter.com/excel-worksheet-functions/236317-sort-link.html)

Dear Friends
I have entered some project numbers ,Staff and % in one sheet in this
sheet, Staff and % are linked with other work sheet. now I want to sort
based on project number. if i sort it, it affects link. further there are so
many work book to be sorted is there any way to sort without doing all
woprking again.
thanks

Project Eq. Staff %
47725 5.9 5.0%
50544 8.65 7.3%
70992 0 0.0%
57523 27 22.7%
69149 16 13.4%
53866 10.9 9.2%
53867 7.1 6.0%
70880 0 0.0%
70958 0 0.0%
70961 1 0.8%
70208 0 0.0%
70213 0 0.0%

Hi,
When sorting are you selecting the whole range, you have to select
everything and then sort by your project column

"Fareez" wrote:

Dear Friends
I have entered some project numbers ,Staff and % in one sheet in this
sheet, Staff and % are linked with other work sheet. now I want to sort
based on project number. if i sort it, it affects link. further there are so
many work book to be sorted is there any way to sort without doing all
woprking again.
thanks

Project Eq. Staff %
47725 5.9 5.0%
50544 8.65 7.3%
70992 0 0.0%
57523 27 22.7%
69149 16 13.4%
53866 10.9 9.2%
53867 7.1 6.0%
70880 0 0.0%
70958 0 0.0%
70961 1 0.8%
70208 0 0.0%
70213 0 0.0%