Quote:
Originally Posted by Hoover
Now that I have done the filtering, I know its the Excel way to check all the boxes. I decided to make the list for our entire region of >100 teams. I would have to do this each week, but I am thinking I could have written a macro to do it. I think it may be done even if I have to generate the criteria statement, but if I remember right the criteria can refer to a range of cells but it has been a while. I am using Excel 2007 and so I don't think I can refer to a range anywhere but on the OPR results worksheet itself.
|
I found an easy way to do this that just takes a minute. An index look up can be used. This is what, because of a limitation in Excel 2007, that this has to be done on the same worksheet and cannot be done in another workbook or even on another worksheet within the same workbook.
For an example index statement
=INDEX($E$1:$F$2542,MATCH(A2545,$E$1:$E$2542,0),2)
where A2545 is the cell containing a team number.