I would appreciate any kind of help with this issue:
I would like to have a workbook with these sheets:
First one (in table format): it is a conection with other excel file, which will be modified as soon as the original excel file is modified (this is an extraction from MS project, so new rows will be added from time to time, and there will be changes in dates and so on)
The second one where I would like to do the next: I would like to have the information from the first sheet, but introducing myself new information (it will consist in adding new rows and columns when necessary) and still having the new rows and modifications from the first sheet as soon as they happen through the connection. I know how to manage updating, this not the point. The thing is how to work on a table from a connection, but having the modifications when it occurs.
Thanks in advance and please let me know if I explain myself clearly and if there is a better way to get the same result.