I'm trying to do something and not sure if I am even going about this the correct way. I'm trying to import data (a few columns) from someone else's excel file. I am able to import the selected columns into my excel file without any issues. I can update and see the new data from the owner's file.
So here's my problem:
My file, I have added some additional columns with data. When I import (or refresh the data) from owner's file into my file, the imported columns and do not match the added columns of my file.
Below is an example of the owners file.
Below is an example of my file with the my added columns, to the far right.
When the owner adds a new row of data in between rows 2 and 3, I then refresh my table (query), row 3 gets bumped down and the added or new data shows up in the correct location, however, the data that is in my columns on the far right does not get bumped down. along with the original data. The owners file has about 20 plus columns of data. I only want a couple of columns. I need his columns because his is the master tracking worksheet. I take his columns and add my columns to the far right and add supporting data to each row. Each row will have different data. When i repeat the process and update my table with his updated information, then my added columns do not move or index with the original data.
The owners excel file is just a excel file. My file, after I import the data becomes a table. I don't think this has any impact on my problem.
I am unable to provide the actual files due to the type of information. I've tried to create these to two sample tables above. The owner adds data in between rows of existing data because the type of data and how it's arranged or grouped by family.