Insert Heading for Unique Data

[kat1585]

Hi All,

I have recently just started working with Macros and have had great success but now I have run into a dead end.
I have a large data file that I need to separate unique cells and insert a heading above each unique value group. So far I have been able to separate the data and insert a blank cell, but now I need to put the relevant heading in the blank cells.

This is what I have

Acme Automotive ACM 123456
Acme Automotive ACM 456879
Acme Automotive ACM 89765456

Blair BLR 45345312
Blair BLR 789748645

Lang LNG 483123168df
Lang LNG dsaf121533
Lang LNG 745614321

And this is what I need

Acme Automotive
ACM 123456
ACM 456879
ACM 89765456
Blair
BLR 45345312
BLR 789748645
Lang
LNG 483123168df
LNG dsaf121533
LNG 745614321


I appreciate any help you can give me

Thanks,

Katie

[patel45]

Please Login or Register  to view this content.