A macro to combine and sum similiar cells

**VBAnoob88** · 06-21-2010, 02:52 PM

I need to create a macro that can create several consolidated and sum tables based on 2 columns of info. The columns have info separated by a space for example:

A 3
B 3
C 1

D 4
A 1
D 2

V 1
V 2
V 3

This should yield
Table 1 Table 2 Table 3
A 3 A 1 V 6
B 3 D 6
C 1

**davesexcel** · 06-21-2010, 07:34 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**VBAnoob88** · 06-22-2010, 08:32 AM

Oh ok thanks for the advice, I guess it was confusing. Ive attached an example of some raw data and the charts that the macro should deliver.

**VBAnoob88** · 06-22-2010, 09:12 AM

i can record a macro to do what I want but it only does a set amount. I want the macro to be able to automatically make the new list based on a blank cell not matter the length of the list.