I'm trying to make a simple worksheet that shows who has played who in a league and the number of times they have played. Across the top column and down the left column are the player names. When I enter the number of times Player X has played Player Y, that value should also show up in the number of times Player Y has played player X.
Mike
Last edited by eznoh; 01-06-2013 at 06:36 PM.
Hi Mike,
Sorry but not following here. Let's just use Plyr 2 (A3) as an example.
If you put a 5 in B3 which means Plyr 2 (A3) played Plyr 1 (B1) 5 times, it is a matrix so it is reversed at the same time.
Some more understanding please?
HTH
Regards, Jeff
Yes, so a 5 would also go in C2 when I enter the 5 in B3 or vice-versa.
Mike
Moderator's Note: As per Forum Rule #12, please don't quote whole posts unless necessary…it's just clutter...Thanks.
Last edited by jeffreybrown; 01-06-2013 at 10:31 AM.
Hi Mike,
I don't think you will get this done with any formula. Sounds like VBA is required.
Is this the direction you want to go and how big is this table in the real workbook?
The table would be 25 x 25.
Moderator's Note: As per Forum Rule #12, please don't quote whole posts unless necessary…it's just clutter...Thanks.
Try this attachment with VBA behind worksheet #1.
Looks like that works, how can I extend it to 25 x 25?Originally Posted by jeffreybrown
I see how the macro works but it looks like I'll have to make dozens of IF blocks, is there a way to make with variables?
Mike
Does this helps:
Please Login or Register to view this content.
As an optionPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
@zbor & John,
Both of these options are great, thanks.
@Mike,
Here is a file with both options.
Last edited by jeffreybrown; 01-06-2013 at 04:38 PM.
Thanks to everyone for your help!
The worksheet would not work when I loaded another spreadsheet which records the scores.
Mike
Hard to say without seeing the offening workbook, but the macro is a worksheet change event so much be placed in the code for the sheet and the ranges need to be updated if moved from the original.
If I open the two different spreadsheets with 2 separate instances of Excel, why should the macros interfere with each other?
I can't see why they would...
Here is the other spreadsheet
You might want to give some explanation here.
I don't see a macro in here that matches what has been done in this thread.
Is this question/query different than the rest of this thread?
Sorry,attached is what was given to me here. By itself it works but when I run it with the previously attached spreadsheet, it works for a short time then stops working.
Jeff's point is...the code you referenceis NOT in your most recent upload.what was given to me hereSo, answer his questionI don't see a macro in here that matches what has been done in this thread.Additionally I don't see a worksheet that resembles what we've been addressing. What worksheet are you trying to run the code against?Is this question/query different than the rest of this thread?
Just to finish up this thread, this was the file I ended up using. It had 2 worksheets, I deleted one and it seems to work fine now. Thanks to everyone who helped me with this, I can't believe how much time you put into it, I appreciate it very much!
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks