I wanna create a sheet with multiple columns of data... I would like to put sort options on the header columns.. so if one of the column is named PLAYERS NAME and then another Header is named AT BATS and then another header is named HITS, I want the viewer to sort any column he wants just by clicking the header either in ascending order or descending order. So if he wants to see who has the most hits, the the viewer should click on Hits and have it go from ascending or descending order. If he then wants to click on Players name it should sort the same way for that column and keep its data in the correct row. How can I achieve this?
edit: This must work in View Mode
Sort(Data, Sort Range) &/or
Filter View(Data, Filter views)? If so, did you reject them because they require the user to make further selections which might make the process more complicated than you wish? So, your goal is simply that the user should click the header and the data will automatically re-sort. Is that righ?. Would you please add a brief description of your research efforts How do I ask a good question? and also describe your own efforts to solve your problem.