Does anyone know of a good macro that will do the following
I have a table in word that I run a macro on to put it in Text format and then open it in Excel. There are multiple files that I need to pull out of Word and combine into one Workbook in Excel. The Workbook should have multiple sheets ie. Monday Tuesday Wednesday
Each sheet will have multiple files for those dates imported from Word. The data is based on the numbers 1 2 or 3.
example.
Now it comes in to Excel like this:
3
Test one two three
Testing one two three
2
Hello
1
One
Two
I would like it to say
3 Test one two three
Testing one two three
2 Hello
1 One
Two
Thanks everyone
I have a table in word that I run a macro on to put it in Text format and then open it in Excel. There are multiple files that I need to pull out of Word and combine into one Workbook in Excel. The Workbook should have multiple sheets ie. Monday Tuesday Wednesday
Each sheet will have multiple files for those dates imported from Word. The data is based on the numbers 1 2 or 3.
example.
Now it comes in to Excel like this:
3
Test one two three
Testing one two three
2
Hello
1
One
Two
I would like it to say
3 Test one two three
Testing one two three
2 Hello
1 One
Two
Thanks everyone