I created a spread sheet to keep up with the SEC college football
records scores stats ect for the upcoming season. I want to sort the
winning percentage columns from high to low. The PCT.'s are in column
F, but when I try to sort it does not sort the row with column's
selected. I wrote some Visual Basic to set the range values up, so the
formulas entered in the other boxes correspond with code written and
needs to move with it. I am unfamiliar with how this needs to be
sorted. Data / sort does not work. I would appreciate any help that
could be provided. Thanks

You do not sort formulas (or there results). Formulas act on other data in
your sheet, if this is not changed then the formula will remain and the
results will be the same. One method might be to copy and paste values
only, then sort on those or sort the entire source range on which the
formula act, using the relevant source column(s) to sequence the sort. Eg

Col A Col B
100 10%
500 50%
400 40%

The formula in column B contains the % of column A relative to the sum of
column A. To sort this list select both columns and sort using column A not
B

--
Cheers
Nigel



"Bumfuzzled" wrote in message
oups.com...
I created a spread sheet to keep up with the SEC college football
records scores stats ect for the upcoming season. I want to sort the
winning percentage columns from high to low. The PCT.'s are in column
F, but when I try to sort it does not sort the row with column's
selected. I wrote some Visual Basic to set the range values up, so the
formulas entered in the other boxes correspond with code written and
needs to move with it. I am unfamiliar with how this needs to be
sorted. Data / sort does not work. I would appreciate any help that
could be provided. Thanks