Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2022, 08:05 AM
beatlerive beatlerive is offline Pull table data from Word and collate into 1 or more sheets Windows 11 Pull table data from Word and collate into 1 or more sheets Office 2021
Novice
Pull table data from Word and collate into 1 or more sheets
 
Join Date: Jun 2022
Posts: 2
beatlerive is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 06-28-2022, 03:43 PM
Guessed's Avatar
Guessed Guessed is offline Pull table data from Word and collate into 1 or more sheets Windows 10 Pull table data from Word and collate into 1 or more sheets Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #3  
Old 06-29-2022, 12:29 AM
beatlerive beatlerive is offline Pull table data from Word and collate into 1 or more sheets Windows 11 Pull table data from Word and collate into 1 or more sheets Office 2021
Novice
Pull table data from Word and collate into 1 or more sheets
 
Join Date: Jun 2022
Posts: 2
beatlerive is on a distinguished road
Default

Thanks
I'll give that a go
Reply With Quote
Reply

Tags
excel 2019, word 2019

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull table data from Word and collate into 1 or more sheets Master File needs to pull in individual sheets and keep formulas intact Bamfer1 Excel Programming 2 10-18-2018 11:32 PM
Pull table data from Word and collate into 1 or more sheets 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
Pull table data from Word and collate into 1 or more sheets 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft