Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I move the tabs at the bottom to the top of the page? | Excel Discussion (Misc queries) | |||
How do I move the worksheet tabs to the top of the workbook? | Excel Discussion (Misc queries) | |||
How do I use the keyboard to move between tabs in a workbook? | Excel Discussion (Misc queries) | |||
sort tabs in a workbook other than one at a time with move or cop. | Excel Worksheet Functions | |||
move the worksheet tabs in a workbook to left | Excel Discussion (Misc queries) |