| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort with Link
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% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i link 3 rows together and sort them as one unit? | Excel Discussion (Misc queries) | |||
| link columns to sort all together | Excel Worksheet Functions | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| Sort/Link Worksheets | Excel Worksheet Functions | |||
Threaded Mode
