|
|
#2
07-27-2022, 05:24 PM
|
||||
|
||||
It is certainly possible to do via code but seems like a lot of work to recreate so I would be wanting to start from your existing excel file.
Your Excel setup does seem overly complicated - why aren't you using a pivot table with filters and sorting to do the work of all your separate sheets? Transferring content back to Word is easy enough. The styles can be applied via VBA as you move that content based on your rules.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
| Tags |
| auto change text style, macros in word |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copy selected text from one document and paste to new document in same position on the page
|
gasparik | Word VBA | 1 | 05-11-2020 05:41 AM |
|
how to copy different text from word into excel on consecutive rows
|
mihnea96 | Word VBA | 4 | 05-08-2017 12:09 PM |
|
Copy text from one table to another table in word document
|
rajsf123 | Word VBA | 1 | 10-21-2016 10:08 PM |
| how to copy addresses in word document to excel/mailmerge list | msnarayanan | Mail Merge | 4 | 10-17-2015 03:17 PM |
| Copy Underline text from Word and Paste into excel | rfaris | Excel Programming | 7 | 10-05-2015 05:56 AM |
Windows 10 
Office 2016
Threaded Mode