Move a Row from multiple Excel Data to the executing table

Hey guys,

im trying to program a script which should look for a term for example "Projectname" in Multiple seperate Excel Data in a seperate folder.

Then when its found it should copy the exact row into the executing Table which i run the Script in.


For Example:
The Script opens the Excel Table, looks if the term "Projectname" exists in it.

If the Term is found, it should then copy the whole row in that table that execute the script into the next free row then goes back to the last table and looks if there is more and repeats the process.

If the term is not found or all terms are found, it closes the Table and opens then next until there are no tables left in the Folder.


And if the Script is done, it should tell how many rows were successfully copied into the main table.

Please Login or Register  to view this content.

I got so far that it looks and finds the Term but i got no idea how i copy that whole row and copy it into the main table D:


Can somebody help me work this out ? I would really appreciate all kind of help :D