using VBA you can do this
See
http://www.rondebruin.nl/copy5.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Tieske" wrote in message ...
using VBA you can do this.
"emma1402" wrote in message
...
Can you have a bulk of data in one sheet then split it into worksheets
based
on a change in data in certain columns?