#1
|
|||
|
|||
Pull table data from Word and collate into 1 or more sheets
I have a table in a word document and I can pull data from it into a new excel sheet.
I have multiple word documents from staff members of different faculties all stored in a single folder. I want to read those in and collate each faculties data on a single workbook on different sheets. In the data I have a Faculty field and I want to collate all the same faculty answers in a single sheet. e.g. all the answers from Math faculty on Sheet named Math, all responses from English faculty on sheet named English etc. I've worked out how to read the table from the word and I'm sure i can get to reading multiple word docs from a single folder, I've just no idea how to take the data and split it onto faculty based sheets. |
#2
|
||||
|
||||
Pull all the data into a single table in Excel and make sure it includes a column for the faculty.
Then you can create a pivot table that filters by faculty. This will give you a dynamic table that can display each faculty by choosing a dropdown filter or you can duplicate it on multiple sheets with a different filter chosen on each.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Thanks
I'll give that a go |
Tags |
excel 2019, word 2019 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Master File needs to pull in individual sheets and keep formulas intact | Bamfer1 | Excel Programming | 2 | 10-18-2018 11:32 PM |
Excel 2013 Pulling data from 1 table to multiple sheets | Justcallmeeesa | Excel | 2 | 04-14-2016 09:15 AM |
Macro to pull data out of a Word table | shanemarkley | Word VBA | 20 | 05-07-2015 01:36 PM |
sumproduct formula to pull info from multiple sheets | Berk21 | Excel | 7 | 01-15-2012 11:41 AM |
Excel VBA: Pull data from web | tinfanide | Excel Programming | 0 | 12-09-2011 02:11 AM |