|
From: emma1402 on 3 Jul 2008 11:41 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 3 Jul 2008 14:48 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 3 Jul 2008 16:23 > 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? >
|
Pages: 1 Prev: Ungroup "+" on a protected sheet Next: How Do I DO IF with DATE |