View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default split data into seperate worksheets by criteria

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?