View Single Post
 
Old 03-24-2014, 01:12 AM
adisl adisl is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2014
Posts: 7
adisl is on a distinguished road
Default Word macro: copy from different tables into one table

Does anyone have an idea how this can be solved.
I need to copy data from tables that are located in several different documents and folders and compile them into one table in a main document.
* The tables will have a different number of rows but have the same number of columns.
* Only to copy the rows that have yes to second column (if possible)
Is deeply grateful if someone can send sample code for this
Example below should present tables
From document 1
ID1 | yes | Text
ID2 | no | Text

From dokument 2
ID3|yes|Text
ID4|yes|Text
ID5|no |Text

From document 3
ID6|no |text
ID7|yes|text

main document to be copied to
ID1|Yes|text
ID3|yes|text
ID4|yes|text
ID7|yes|text




Sincerely Svein

Last edited by adisl; 03-24-2014 at 03:18 AM. Reason: presentation was poor
Reply With Quote