From: emma1402 on
Can you have a bulk of data in one sheet then split it into worksheets based
on a change in data in certain columns?
From: Tieske on
using VBA you can do this.

"emma1402" <emma1402(a)discussions.microsoft.com> wrote in message
news:AC987B4E-687E-4E6B-B887-04715102677C(a)microsoft.com...
> Can you have a bulk of data in one sheet then split it into worksheets
> based
> on a change in data in certain columns?

From: Ron de Bruin on
> using VBA you can do this

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tieske" <thijs(a)thijsschreijer.nl> wrote in message news:4B801BDA-E069-4AD8-A1B4-3788A1857AAF(a)microsoft.com...
> using VBA you can do this.
>
> "emma1402" <emma1402(a)discussions.microsoft.com> wrote in message
> news:AC987B4E-687E-4E6B-B887-04715102677C(a)microsoft.com...
>> Can you have a bulk of data in one sheet then split it into worksheets
>> based
>> on a change in data in certain columns?
>