jaylotheman
10-23-2010, 04:09 PM
For whatever reason I've been assigned to this task for taking an Excel Spreadsheet with two columns of values (please see attached file). I only have a very basic understanding of VBA but need to do the following which I believe to be done best via a dynamic multidimensional array:
Create an application routine that allows a user to merge the asset data the separate restaurant companies, rename the newly formed company and add it to the list (via a userform).
In addition, the merged restaurant companies must be removed from the list.
Ideally the resulting list will be sorted alphabetically once the merger is completed.
So basically, For e.g. (not in spreadsheet)
Column A Column 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
Column A Column B
Super Wendy-BK-Harvey's 1500
Make sense?
Can someone help me with the code to do this? Any help would be appreciated thanks.
Create an application routine that allows a user to merge the asset data the separate restaurant companies, rename the newly formed company and add it to the list (via a userform).
In addition, the merged restaurant companies must be removed from the list.
Ideally the resulting list will be sorted alphabetically once the merger is completed.
So basically, For e.g. (not in spreadsheet)
Column A Column 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
Column A Column B
Super Wendy-BK-Harvey's 1500
Make sense?
Can someone help me with the code to do this? Any help would be appreciated thanks.