I currently have a "current year" sheet with names listed in column 1, numerical attributes related to the names in following columns, then a score based on the attributes in the last column. The next few sheets are previous years formatted the same way (names in column 1 and the same attributes in the following columns) except with no score as the last column. My goal is to have the first sheet, "current year", populate its attributes by a drop down menu where a single year or average of all years can be selected AND be able to sort the 'score' in the last column (which is based off of the populated attributes). I created an encompassing IF function in each attribute cell to pull data from a specific year sheet based on the drop down menu selection, but sorting a table with formulas never works. I am wondering if there is an alternative option to populate each person's attributes for a given year without having a formula in each attribute cell, so that the table may be sorted.
Bookmarks