Move list to different tabs
 

I have a spreadsheet with a list of data. At each change in, for example,
the date, there is a page break. Is there a way to take to data and put it
on separate tabs (at each page break or change in date)? I would rather not
copy and paste large amount of data onto 40 separate tabs manually if there
is a quick/easy way to do this. I am also not versed in visual basic codes.
Thanks in advance!

Move list to different tabs
 

Hi Meredith

Maybe this example is working for you
http://www.rondebruin.nl/hpagebreaks.htm



--

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


"Meredith" wrote in message ...
I have a spreadsheet with a list of data. At each change in, for example,
the date, there is a page break. Is there a way to take to data and put it
on separate tabs (at each page break or change in date)? I would rather not
copy and paste large amount of data onto 40 separate tabs manually if there
is a quick/easy way to do this. I am also not versed in visual basic codes.
Thanks in advance!

Move list to different tabs
 

Wonderful!! Thank you very much!

Meredith

"Ron de Bruin" wrote:

Hi Meredith

Maybe this example is working for you
http://www.rondebruin.nl/hpagebreaks.htm



--

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


"Meredith" wrote in message ...
I have a spreadsheet with a list of data. At each change in, for example,
the date, there is a page break. Is there a way to take to data and put it
on separate tabs (at each page break or change in date)? I would rather not
copy and paste large amount of data onto 40 separate tabs manually if there
is a quick/easy way to do this. I am also not versed in visual basic codes.
Thanks in advance!