I have approximately 1,200 Word files and I want to create a single Excel file that has a sheet titled for each of those Word files. ALSO, I want to copy all of the contents of each Word file into A1 of the sheet that matches it. Is this possible to do with a macro? Otherwise, I have alot of copy/paste to do.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Multiple sheets with names and data from Word files
- Thread starter knpaddac
- Start date
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Similar threads
- Question
- Replies
- 0
- Views
- 193
- Question
- Replies
- 0
- Views
- 50
- Question
- Replies
- 0
- Views
- 213
- Replies
- 0
- Views
- 183
- Replies
- 0
- Views
- 423
