Thread: VBA Excel
View Single Post
Old 10-23-2010, 03:40 PM   #31
iggyntangs
Scoring Winger
 
iggyntangs's Avatar
 
Join Date: Oct 2010
Exp:
Default

The part I'm having wrapping my head around is how combining values within a column and linking it with the values beside that column to create an entire new Name-Value...

For e.g.

A B
Harveys 400
BK 500
Wendy's 600

If I want to create a dynamic multi-dimensional array that merged all of A so that I could create a "super-entity" so combine A1-A3 and be able to create a new name for it so "Super Wendy-BK-Harvey's" and at the same time it auto-sums values B1-B3 so it creates

A B
Super Wendy-BK-Harvey's 1500

Make sense?

Any help, because I'm having trouble just wrapping my brain around how to start this...

EDIT: Even if anyone knows anything or where I can find online resources for how to do a multi-dimensional dynamic array that'd be awesome.

I won't lie this is one thing our Prof didn't do a great job teaching.
iggyntangs is offline   Reply With Quote