Rufus 2006
Board Regular
- Joined
- Dec 15, 2005
- Messages
- 104
Everyone:
This board is awesome. I have a workbook with 93000 columns in it and rows A-G populated. I am trying to create something where I can choose a name and the info I need will automatically display in a chart. I have looked into a pivot table and such but I don't think that is what I need. I am just learning (and willing to learn more) VBA, but I haven't learned enough about it to even try to create what I want in that by myself. Here is what the chart looks like.
Name Event Date Days Btw Events Weight Total +/-
Jay World 1/1/14 52.08 200
Jay Local 2/1/14 30 52.03 205 5
Pete Local 1/10/14 69.72 275
Pete Nat 3/10/14 60 68.58 270 -5
Somehow, I need to be able to select Jay and have his numbers come up in a chart. I also need for the horizontal axis labels for each meet to show the Date, Days Btw Events, and the Event.
Hopefully this is clear. I am using Excel for Mac 2011.
Thanks in advance for all the help
Rufus
This board is awesome. I have a workbook with 93000 columns in it and rows A-G populated. I am trying to create something where I can choose a name and the info I need will automatically display in a chart. I have looked into a pivot table and such but I don't think that is what I need. I am just learning (and willing to learn more) VBA, but I haven't learned enough about it to even try to create what I want in that by myself. Here is what the chart looks like.
Name Event Date Days Btw Events Weight Total +/-
Jay World 1/1/14 52.08 200
Jay Local 2/1/14 30 52.03 205 5
Pete Local 1/10/14 69.72 275
Pete Nat 3/10/14 60 68.58 270 -5
Somehow, I need to be able to select Jay and have his numbers come up in a chart. I also need for the horizontal axis labels for each meet to show the Date, Days Btw Events, and the Event.
Hopefully this is clear. I am using Excel for Mac 2011.
Thanks in advance for all the help
Rufus