Excel - Copy / paste from word to excel

[jimmy11]

Hi,
I am trying to copy a data from word to excel ( multiple files)…Now we are able to copy the data from word to excel, but would like to add simple two steps:
1. Transpose (the rightmost cells only) and copy/paste row one in the result sheet. Then the second file will be pasted row 2 an so an.
2.Since we are copying many files( 100 files) from word to excel, would like to delete the previous file from the sheet1 and also get prompt to select the second file ( the new file to copy/paste)

Sample word and excel file attached..The Result tab is the desired result

Below is the code we are now using..

Please Login or Register  to view this content.

Thanks in advance...

Jimmy

[jeffreybrown]

Maybe you should consider posting a link to this thread (Cross post) in your other post as a courtesy.

[jimmy11]

Thanks...The other posting doesn't have sample attachment, thats why i reposted here...
http://www.mrexcel.com/forum/showthr...ght=paste+word

Thanks