I am thinking that a solution may be to match the local Headers in my local table to the column headers (Rows A&B) in the Source spreadsheet
I for one, have no idea on how this could be possible if the names or counts of the columns are subject to change. There would have to be some sort of consistency, otherwise I can only see a linked table with a manual reconstruction of any queries or transfers that are needed. What assurance do you have that one of these named columns will not be deleted? Can you convince the workbook owner to define ranges that will not be altered?
I think you mean rows 1 or 2, or columns A or B
Last edited by Micron; 12-21-2016 at 11:09 PM.
Reason: correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.