Change Macro to look at name vs row range

[Kim B]

Hi all. What is the simple way of telling a macro to split data at the point of a name change vs a row range. So instead of saying this
Rows("1:121").Select
Selection.Copy

say when name changes select
selection copy

Both ABC would be on the same sheet
Both XYZ would be on the same sheet

Name=ABC Fast Foods Portland Customer Group
Name=ABC Fast Foods Maine Customer Group
Name=XYZ Health Foods Chicago Customer Group
Name=XYZ Health Foods Delaware Customer Group

As always

Thank you

 

[My Aswer Is This]

S

Hi all. What is the simple way of telling a macro to split data at the point of a name change vs a row range. So instead of saying this
Rows("1:121").Select
Selection.Copy

say when name changes select
selection copy

Both ABC would be on the same sheet
Both XYZ would be on the same sheet

Name=ABC Fast Foods Portland Customer Group
Name=ABC Fast Foods Maine Customer Group
Name=XYZ Health Foods Chicago Customer Group
Name=XYZ Health Foods Delaware Customer Group

As always

Thank you

And what would happen after.
Are you saying ABC would be cut and pasted on sheet named ABC
And XYZ would be cut and pasted on sheet named XYZ.

 

[Kim B]

Cut and pasted in separate workbooks but the rest of the macro handles that ok. It is a recorded macro as the user is not familiar with vba at all. They just need to extract and group all the data for each company by name instead of row because the row numbers may change.

 

[Burrgogi]

Cut and pasted in separate workbooks but the rest of the macro handles that ok. It is a recorded macro as the user is not familiar with vba at all. They just need to extract and group all the data for each company by name instead of row because the row numbers may change.

What column are those company names located in? At the very least you should provide a screenshot of your workbook or upload a sample file. Without knowing what columns you're dealing with, no one will be able to give you a concise answer.

(You can also use XL2BB on the forums to show us your current worksheet setup.)

 

[Kim B]

Here is a screen shot, I don't have XL2BB at this location. There are merged columns beginning in row 8 (A-J). This may look familiar as a macro was built to split each break in customer regardless if it was the same customer. This user needs all same customer grouped into one workbook. They will not be unmerging. They have a macro doing what they want it to do they recorded but they don't know how to break the data based on name change vs row number which is how the recorded macro works.

 

[Burrgogi]

Sorry but I don't know how to help you. With those company names contained in merged cells, it's a headache and beyond my VBA capabilities.

It is far better to use 'Center Across Selection' method rather than merging cells. I only use the latter option only as a last resort.