VBA : Aggregating Excel cells whose rows contain certain text
Posted on 2004-11-03
In VBA, I want to write a Macro that aggregates the values of a column depending on the text values of another column.
For eaxmple, I have data like this:
I want to write something in VBA where I take this date and run a macro to generate:
In reality, the raw file contains about 800 lines of data and the cells will not always be in the same place.