Chris Waller
Board Regular
- Joined
- Jan 18, 2009
- Messages
- 183
- Office Version
- 365
- Platform
- Windows
I have been emailed a large number of Word documents which contain a large number of tables. I have been asked to put the data onto an Excel Spreadsheet so that some analysis can take place. Each Word document contains 7 tables. However, the tables vary in number of rows and columns (approximately 66 cells in total). I am only interested in the response to each question rather than the questions themselves. What I would like to do is copy the information from all these tables onto one Excel Spreadsheet.
On an Excel Spreadsheet I have created a row that contains all the questions what I need to do now is to copy\import the answers and place them on a single row under the relevant columns. I am trying to do some analysis and I need all the relevant data from all the Word Documents placing on a single Spreadsheet. Currently I do not know if the data on the Spreadsheet will be in the same order as the cells within the Word Tables. As my VBA knowledge is next to nothing, I would appreciate some help.
On an Excel Spreadsheet I have created a row that contains all the questions what I need to do now is to copy\import the answers and place them on a single row under the relevant columns. I am trying to do some analysis and I need all the relevant data from all the Word Documents placing on a single Spreadsheet. Currently I do not know if the data on the Spreadsheet will be in the same order as the cells within the Word Tables. As my VBA knowledge is next to nothing, I would appreciate some help.
