![]() |
#12
|
|||
|
|||
![]()
Thanks Paul
So if the at least .6cm is selected for each table there is no way or automating the auto alignment macro I am seeking The reason why it is its set as at least we when we copy the data manually from the “ sample 1 : attached report document in portrait to the corrective actions word document in landscape the cell can changes from a single line to a double line thus making the cell txt alignment different , so then its needs to be adjusted as the width of the cell changes in landscape . So the process I use is to select the contents from the Sample 1 table , rows seven onwards and paste in the other document table by adding lines below , Then I go through the table and align all the cells correctly for presentation and printing , thus the need for some sort of cell txt alignment macro. . The problems all ways occurs going from portrait to landscape as the cell for the information changes in width and then need to be aligned to suit . I have been work this way for three years and I have tried other ways but theses steps are the quickest and then its just checking the alignment and txt positioning the cells . As the amount of row each time change on each table and the paste location changes in the second document . At the moment I just use the recorded macro row by row to check and correct if required in the second document Thus I use the recorded macro to check the cell alignment light it checked so I know they have been checked and I move on Can you advise on different settings some better way to carry out the massive task with the copied table data between tables and between Thanks Grant |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
![]() |
markand_bhatt2008 | Excel | 1 | 04-29-2013 07:46 AM |
![]() |
gib65 | Word | 1 | 06-02-2012 03:03 PM |
![]() |
Jazz43 | Word Tables | 2 | 08-19-2010 08:07 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |