I have an excel workbook with 13 sheets in it. These sheets are populated with data on companies (see worksheet example posted). I want to create a master sheet at the end that extracts data from the rest of the workbook based on it meeting certain criteria. In each of the 13 sheets, there are anywhere between 1-30 rows of companies, with 21 pieces of data about them in the columns. 9 of these columns have rankings in them on a scale of 1-4, which are then averaged in the last column. If this average is above 2, I want the 9 ranking columns, as well as the column identifying the company to be extracted into the master sheet at the end. I am posting an example of what I mean on the sheet.
Solved by M. E. in 23 mins