Try Pivot Table

http://contextures.com/xlPivot10.html

If this post helps click Yes
---------------
Jacob Skaria


"Lost in Excel" wrote:

Hello, I need help creating a macro, and can't figure out how it should be
written.

I want the macro to look for duplicate names in column B, add figures in
columns N to X, and merge information to one line.

The names only appear twice in my report, but I need to merge the YTD info
(columns N to X).

Doing this manually is taking forever.

Any assistance would be appreciated. Thanks.