Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting a range of cells that get value from other cells
I'm trying to sort a range of cells that get their value from the same
worksheet but in a different section. ie: I have a list of names starting at A5:A25. On another part of the worksheet, I have cells that get their value from =A5, =A6 etc. I want to be able to sort the second area but every time I select sort, nothing happens to the data in the second area. I have searched through the functions looking for something that will let me use the "Contents" of the A5, A6 cells etc. in the area that I want to sort, but I haven't found anything yet. This whole process works if I have the second area on a seperate worksheet and reference like so: =ORIGWORKSHEET!A5 etc. Any help is greatly appreciated |
#2
|
|||
|
|||
Hi Matt
If you refer as =A5 etc, nothing will happen. If you use =$A$5 etc, it will sort "Matt Caswell" wrote: I'm trying to sort a range of cells that get their value from the same worksheet but in a different section. ie: I have a list of names starting at A5:A25. On another part of the worksheet, I have cells that get their value from =A5, =A6 etc. I want to be able to sort the second area but every time I select sort, nothing happens to the data in the second area. I have searched through the functions looking for something that will let me use the "Contents" of the A5, A6 cells etc. in the area that I want to sort, but I haven't found anything yet. This whole process works if I have the second area on a seperate worksheet and reference like so: =ORIGWORKSHEET!A5 etc. Any help is greatly appreciated |
#3
|
|||
|
|||
I can't believe it was that simple. I have been pulling my hair out (what
hair I have left) for the last 2 hours. I can't thank you enough for pulling me back from the brink of insanity! matt "Matt Caswell" wrote: I'm trying to sort a range of cells that get their value from the same worksheet but in a different section. ie: I have a list of names starting at A5:A25. On another part of the worksheet, I have cells that get their value from =A5, =A6 etc. I want to be able to sort the second area but every time I select sort, nothing happens to the data in the second area. I have searched through the functions looking for something that will let me use the "Contents" of the A5, A6 cells etc. in the area that I want to sort, but I haven't found anything yet. This whole process works if I have the second area on a seperate worksheet and reference like so: =ORIGWORKSHEET!A5 etc. Any help is greatly appreciated |
#4
|
|||
|
|||
Hi Matt,
Glad I could be of help my friend. Have a nice day! "Matt Caswell" wrote: I can't believe it was that simple. I have been pulling my hair out (what hair I have left) for the last 2 hours. I can't thank you enough for pulling me back from the brink of insanity! matt "Matt Caswell" wrote: I'm trying to sort a range of cells that get their value from the same worksheet but in a different section. ie: I have a list of names starting at A5:A25. On another part of the worksheet, I have cells that get their value from =A5, =A6 etc. I want to be able to sort the second area but every time I select sort, nothing happens to the data in the second area. I have searched through the functions looking for something that will let me use the "Contents" of the A5, A6 cells etc. in the area that I want to sort, but I haven't found anything yet. This whole process works if I have the second area on a seperate worksheet and reference like so: =ORIGWORKSHEET!A5 etc. Any help is greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |