Spit data into various rows using VBA

[kay007]

Dear Experts,

I need help with a subset of data that i am working on. I got a list of cars in which the year has been concatenated. However, i want to separate the data into their various years.

Please see the attachment for a sample of the data and the desired output.



Any help will be much appreciated.

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[Pete_UK]

Do you want to list all the cars on a separate sheet, or just the row highlighted (i.e. Nissan Datsun)?

Pete

[kay007]

Perfect Jindon.. Exactly what i am looking for.. Thanks a lot..

[kay007]

Thanks Pete... A separate sheet is ideal so that that i can keep the source.. Many thanks for showing interest as well..