Thread: OPR after Week Four Events
View Single Post
  #33   Spotlight this post!  
Unread 26-03-2013, 11:06
Hoover's Avatar
Hoover Hoover is offline
Registered User
no team (None)
  
Join Date: Mar 2013
Rookie Year: 2013
Location: New Jersey
Posts: 116
Hoover is a name known to allHoover is a name known to allHoover is a name known to allHoover is a name known to allHoover is a name known to allHoover is a name known to all
Re: OPR after Week Four Events
Quote:
Originally Posted by Ed Law View Post
Please read the instructions tab. The answer is there. The information you are looking for is available in one of the tabs. Filters are set up for you so you can select only the teams that is going to a particular regional/district.
Hi Ed,

Thanks. I am getting the hang of it now. After filtering it gave me exactly the list that I wanted.

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.
Reply With Quote