Hi guys-I'm currently working on a spreadsheet that tracks weather for daily Major League Baseball games. I've completed a web query that includes each games relative information, and I'm looking for a way to possibly create named ranges for each game so I can vlookup each game to get the information compiled in seperate sheets.
I'm not sure if that explains my situation clearly enough, but I have included an example which might give a better idea of what I'm trying to accomplish. Any help would be greatly appreciated.
Note: Each day the games will be in different order and there are days where there are 5 games, and days where there are 15. Not sure if that makes things more complicated or not.
Bookmarks