LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 128
Default Split Up Excel Table

Hi All,

I have a table of data in excel that I need to split into numerous
sub-tables based on the total row height, in order to copy and paste them
into a powerpoint presentation.

I need to split up the tables by the total height of all the rows that can
be fitted onto a page. i.e. if I specify 20pt as the max row height per page
and the data table is 100pt I would need 5 pages to split up this data.
(this does not take into account the headers that would be copied to each
page).

Any help would be gladly appreciated - Thanks

Andi



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal pivot table data to show % split Sarah (OGI) Excel Discussion (Misc queries) 0 November 5th 08 12:25 PM
How to Split the table and keep the header on each portion. capxc Excel Discussion (Misc queries) 1 July 30th 08 11:04 AM
Split a table into two Lovis Excel Discussion (Misc queries) 1 November 20th 07 04:49 PM
Split table into smaller tables & into different worksheets each Pradeep Excel Worksheet Functions 8 May 9th 07 05:39 PM
Split cell as we do in table in word PK Baranwal New Users to Excel 2 March 9th 06 06:55 AM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"