Sort with Link

  • Thread starter Thread starter Fareez
  • Start date Start date
F

Fareez

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
 
Back
Top