Export a separate CSV when a row column word changes

[imamustardman]

hi,

Sorry i haven't been on here for years but I am after a macro or something that will run through my worksheet and create a new CSV file everytime a word changes. Will try and explain below:

Col1 Col2 Col3 Col4
Smith John info info
Smith Dave info info
Smith Boris info info
Jones Jane info info
Johnson Bill info info

So from the above I need the information in a new CSV for Smiths (this would contain the 3 entries), then another .csv file for jones, then another one for Johnson.

Many thanks in advance.

James.

[JBeaucaire]

This will do what you've outlined:

Please Login or Register  to view this content.

[imamustardman]

Wow, thanks very much, I wasn't expecting a speedy solution. Many thanks I will try it out and get back to you but I'm sure it is perfect.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.