Help! Macro: Combine rows with 'same name entry'

[cjhiggins]

Hello Excel experts!

Please your my only hope I'm trying to create a macro that will consolidate rows with the 'same name' in Column 'B' within the entire table.

So that if 'John Dear' has two or three, or four entries on my table they will be combined into one entry. Consider that names will be added to this table on an on-going basis so it would need to be applied to the entirety of the affected columns below.

Column 'A' = Rank (NOT AFFECTED Please)

Column 'B' = Employee (String) Yes
Column 'C' = Total Sales (Currency) Yes
Column 'D' = Transaction (Integer) Yes

Column 'E' = Total Sales/Transaction (Currency) NOT AFFECTED because this column will automatically divide column 'C' by 'D'

For the macro I would need it designed so that it combines the entries only if the names are completely identical (first and last name).

Attached is my example spreadsheet. I would greatly appreciate any help with this as I just don't have the skills to write this myself. Thank you.

[dazwm]

Can you not use a Pivot Table?

[cjhiggins]

No unfortunately that would require me to retool my entire workbook that I'm using now. Which would probably be a disaster for me...

[dazwm]

Can you provide a sample of how you want it to look as well as the raw data you have already posted.

[Richard Buttrey]

Hi,

Does the attached with a Pivot Table help?

[cjhiggins]

I have added the spreadsheet with an example of how I would like it to look after the macro has been applied.

[Richard Buttrey]

Hi,

Since there's a one to one mapping why not just link the cells in your layout to the PT layout. PTs are much easier to construct for this sort of analysis and usually a PT is sufficient in its own right. If you want a pretty layout to meet some sort of business standard then use the PT as the basis and work from there. You can usually avoid the need for macros.

[FDibbins]

See if the attached will give you what you want. It uses a helper column (which you can hide), instead of a macro

[cjhiggins]

Unfortunately this doesn't help me.

[FDibbins]

please expand on your answer...why doesnt it work for you?