the_biochemist
New Member
- Joined
- Oct 19, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi I have searched but am either searching for the wrong thing or it isnt immediately apparent that a post is looking for the same thing.
Essentially I have a word document with some 80 headings in it and I need to work through it updating whilst cross referencing other documents and speaking with people about the content. As such I am going to put a summary table at the start of each section so that I can keep track on what is going on and where I am. The table will always be the same layout and left hand column content just with different details for each item in the right hand column. example table below:
I want to find a way to extract the content from each of these tables to a spreadsheet where the bold items on the left are the column headers and the detail on the right is the respective cell content for each row.
The word document will have a million and one other tables but it is just these ones I am wanting to pull out so will need to ignore ones that don't look like this.
I assume this is a macro/vba problem; i have an appreciation of vba from many moons ago when i dabbled with vb6 development so can likely pick apart a script to get it going but think it is a little too distant in my memory for me to start from scratch.
Really would appreciate any advice or help you can give.
Essentially I have a word document with some 80 headings in it and I need to work through it updating whilst cross referencing other documents and speaking with people about the content. As such I am going to put a summary table at the start of each section so that I can keep track on what is going on and where I am. The table will always be the same layout and left hand column content just with different details for each item in the right hand column. example table below:
OBC Section | 2.1 |
OBC Page | 28 |
FBC Section | 1.1 |
Activity | Update |
Author | ML |
MEH Contacts | LM |
Variance to OBC | Reflect changes |
Information Required | Detail of changes |
Questions | n/a |
Status | To Start |
I want to find a way to extract the content from each of these tables to a spreadsheet where the bold items on the left are the column headers and the detail on the right is the respective cell content for each row.
The word document will have a million and one other tables but it is just these ones I am wanting to pull out so will need to ignore ones that don't look like this.
I assume this is a macro/vba problem; i have an appreciation of vba from many moons ago when i dabbled with vb6 development so can likely pick apart a script to get it going but think it is a little too distant in my memory for me to start from scratch.
Really would appreciate any advice or help you can give.