View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 208
Default Refering to other tabs easily

Is it possible to use the month name "November2" so this way it is unique?

"Max" wrote:

I'm trying to add second set of games for the month of November


That's not possible. You cannot have 2 "November" tables in that sheet. Each
of the 12 monthly tables must be unique as MATCH can only return the 1st
matching instance.

For your intents, I'd suggest that you simply use* another copy of the
earlier file that worked to record the 2nd set of games. And if you have a
3rd set of games, use yet another copy of the file.
*File save as ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote in message
...
Max,

I'm trying to add second set of games for the month of November, when I
add
new lines in the players tab it gives me an error and then it turns the
rest
of the players stats into errors. Can you please help?

Here's a link to the workbook for reference:

http://www.mediafire.com/?1jn2tv1ndw9

Thanks!