Hey Dobber Nation,

Now I know these forums are filled with wisdom of all sorts and I'm hoping I can find some in the form of help with Visual Basic for Applications (VBA) in excel. It's pretty straight forward coding I'm doing, its essentially reading the value in one column which identifies the type and summing the column beside it for all values that fall into the type.

I'm doing an analysis of the last 15 years of NHL drafts and this code would save me a good (and long) days work. If there is anyone out there who knows anything about VBA, please let me know and we can likely hash this out in a couple of solid lines of code.

Reward? Rep of course and recognition on the analytical paper. Its about all I can offer, but hopefully someone is interested in giving a few posts to help me with this!

Thanks guys.

TPC

__________________

C - C. Giroux, J. Pavelski, J. Toews, P. Bergeron
LW - D. Sedin, J. Franzen, D. Perron, R. Clowe
RW - C. Perry, M. St. Louis, M. Erat, B. Wheeler, V. Tarasenko
D - K. Yandle, K. Letang, M. Green, S. Salo, C. Ehrhoff, R. Diaz
G - H. Lundqvist, T. Rask, J. Hiller, C. Ward
IR -

2011-2012: 1st Place Regular Season
2010-2011: 1st Place Regular Season
2009-2010: 1st Place Regular Season

Shoot me a PM with the details (and the Excel file) and I'll take a look at it. I know VBA.

__________________
SIODL: 12-Team H2H Limited Keeper League
Back-to-Back Defending Champ!

Rosters: 3C, 5W, 5D, 1U, 2G, 9B, 2IR
Keep: 4 F, 2 D, 1 G, 1 U (F or D)
Skater Stats: G (3), A (2), +/- (0.3), PIM (0.4), PPP (0.5), SHP (1), GWG (1), SOG (0.3), Hits (0.1), FW (0.05)
Goalie Stats: W (5.5), Saves (0.25), GA (-2), SHO (2)

Tentative Keepers:
F1: Crosby
F2: Tavares
F3: Backstrom
F4: Perry
D1: Weber
D2: Pietrangelo
G: Rinne
U: Parise

Trade Bait: Krejci, Wheeler, Voracek, Streit, Franson, Crawford

Chinny (from the forums) could potentially help you out as well - depending on his time.