split data into seperate worksheets by criteria

[emma1402]

Can you have a bulk of data in one sheet then split it into worksheets based
on a change in data in certain columns?

 

[Tieske]

using VBA you can do this.

 

[Ron de Bruin]

using VBA you can do this

See
http://www.rondebruin.nl/copy5.htm