how do I split contents of a cell into separate rows and carry over the data in other columns to each new row?

[redchelle123]

Hi there,

In column A I have locality names (ranges from 5 to 20 localities) separated by a line feed (Alt Enter). Columns B to G contain a number or word that relates to the group of localities in column A.
I want to split the localities into separate rows and copy the values in columns B to G.
I found a macro at (http://www.mrexcel.com/forum/showthread.php?t=345162) that split the localities successfully but it did not carry the other column values to the new rows.

Any help would be greatly appreciated.

Thanks in advance!
Rachelle.

 

[redchelle123]

Thanks for your help hiker95 - I got the data how I wanted it and just added the single locality entries back in after I ran the macro.

Hopefully others can use the macro for the same job!