Hello guys,
I'm in process of automating the input on several workbooks. The input sheet is formated as table so I dont need to copy the formulas all the way down.
The way I do now:
1- Open the main workbook
2- Open the text file on excel
3- Text to columns on the text file
4- Copy text to the bottom of the main workbook
5- Done, all the formulas are copied down along the data I just pasted.

But if I input the data through the "import from text" tool the table is not updated.
Similar problem when I need to import data into a table, instead of placing the data inside the table, the excel insert new columns, paste the imported data there and move the table to the right.