If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Word tables be smart?
I'm attempting to make a sort of cascading (if thats the right word)
table.. what I mean is this.. I have a table that is X amount of rows long and 3 columns wide.. the rows continue for as long as the data is needed.. The table is created from Mail Merge for making labels.. the standard sheet is 10 rows 3 columns for making labels and printing them.. addresses get pulled from a database output, then formatted by the Mail Merge - and inputted into the X rows and 3 columns.. Then the mail merge inputs the data, it is alphabetically ordered running from left to right -- for example A B C D E F G H I So - here is my problem.. I have 12 pages of addresses (X columns, 3 columns).. all in alphabetical order left-to-right... and I want to insert a NEW address that.. I want to insert a cell anywhere, and when I do - it will push all the other addresses down in the correct order.. here is my example BEFO A B C D E F G H I after i insert a cell: A A B C D E F G H I .... So can word be smart and do that? Is there anyway to write a macro to do this? If you don't understand what i'm trying to say toss me an email and I can try to explain it better and send you an example file.. Thank you! -Chris B. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Can Word tables be smart?
|
Thread Tools | |
Display Modes | |
|
|