In cell A1, there is a drop down box that has text referring to certain types of positions in baseball in the named range AVAILABLE.
In column A below there is a list of names returned from the range AVAILABLE based on the position selected in A1. Right now I am using INDEX/MATCH/OFFSET to find the name in the range based on manually sorting the range AVAILABLE by position (column C), then by a statistic that measures production (column E).
In cell U1, there is a drop down box that has text referring to certain types of statistics in the range PITCH2016.
I'd like to write a formula or macro that will read the text in cell U1, sort the range PITCH 2016 (by the column starting with the text in U1) and also sort the range AVAILABLE by the same text selected in U1 (and also keep the sort of the range AVAILABLE by position as the first layer).
Would this be done easier by writing one large macro that reads the selected text in U1, or by creating buttons linked to individual macros that would sort each range by category, one at a time?
I can show my work so far if needed but it's a 2.35 MB document.
Any ideas?
In column A below there is a list of names returned from the range AVAILABLE based on the position selected in A1. Right now I am using INDEX/MATCH/OFFSET to find the name in the range based on manually sorting the range AVAILABLE by position (column C), then by a statistic that measures production (column E).
In cell U1, there is a drop down box that has text referring to certain types of statistics in the range PITCH2016.
I'd like to write a formula or macro that will read the text in cell U1, sort the range PITCH 2016 (by the column starting with the text in U1) and also sort the range AVAILABLE by the same text selected in U1 (and also keep the sort of the range AVAILABLE by position as the first layer).
Would this be done easier by writing one large macro that reads the selected text in U1, or by creating buttons linked to individual macros that would sort each range by category, one at a time?
I can show my work so far if needed but it's a 2.35 MB document.
Any ideas?