VBA not deleting rows

[WFMBeerGeek]

I've been using this great Macro by Jerry Beaucaire to copy information from duplicate rows. The Macro is supposed to delete the rows after merging them but for some reason it is not deleting them - it merges the information perfectly but now I've got multiple rows.

My workbook has numerous columns, about 125 for different items. In my worksheets, the key column is "F" which contains the customers' last name.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[Richard Buttrey]

Please upload the workbook and explain what you expect to happen when the macro has run.

[WFMBeerGeek]

The Workbook is attached -

What I need to have happen is for the multiple rows with the same customer name to be merged into one row -
From this:
excel sample.jpg

to this:

excel sample 2.jpg

The macro is copying all the information onto the first line. Using Rich Biller in the images as an example - everything is on the first line and the second should be deleted.



Thanks,
Steve

[daboho]

Perhab

Please Login or Register  to view this content.

[WFMBeerGeek]

Perhab

Please Login or Register  to view this content.

This seems to be deleting the first row of the duplicated data, which is the row that has all the joined data on it.

Is there a way to change it so that it deletes the second (and in some cases third) row of data?

Thanks

[daboho]

my code has delete second of data