• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Can text in a excel spreadsheet be a link to sort the page based on the text?

Can text in a excel spreadsheet be a link to sort the page based on the text? foe example I have a sheet of baseball stats what id like to do is click on avg and the sheet sort by average from hight to low or click on 2b and sort by doubles same way. Is this possible and how do i do it if so?
0
darrellbuckley
Asked:
darrellbuckley
  • 2
  • 2
1 Solution
 
Kannan KManager - EngineeringCommented:
Hi,

Could you please explain in detail or provide sample, Sorry didn't get the point.

KK,
0
 
Arno KosterCommented:
You could make separate worksheets in which you set the desired sorting, and use hyperlinks to point to the specific sorted worksheets.

If you want to change the sorting on the active worksheet, you would be needing macro code to change the sorting to your liking.

In the latter case it would be helpful if you could post an example for us to work on
0
 
darrellbuckleyAuthor Commented:
On the total pages I would like the ability to click on the top row and have the data below the frozen fram sort.
BookMaster.xlsx
0
 
Kannan KManager - EngineeringCommented:

Hi,

Please refer the below link get your requirement

http://dmcritchie.mvps.org/excel/sorting.htm

KK,
0
 
darrellbuckleyAuthor Commented:
thanks.. side not how to only show whole numbers at the axis there wouldnt be a need for 1.2 value when talking about runs batted in it would only be 1 2 3 4 ect.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now