Forum Discussion
How to update unlinked columns according to content of a column linked to a external source file?
Hello to all of you. Situation: I have created an excel file with about 20 columns, of which the first 4 columns (A to D) are linked (external references) from a source file. When I update the sou...
Do the columns from E on have an explicit relationship with columns A to D - do they have a value in common, for example?
Hi HansVogelaar thanks for your question.
No, the columns after E do not get/fetch any infos from the columns A to D. I just need the ranges to be correctly aligned to oneanother, whenever A - D are updated from another excel file.
I don't see how that would be possible if there is no link between the two sets of data.
- Column A in the source file is empty. If I added a unique number for each range from 1 to n, would that be then possible?
Power Query could work if you have unique ID. Not straightforward solution and requires refresh, nonetheless.
You may query data in Sheet1, return result in Sheet2, add any columns you wish, query it again and merge with the source. If that's an option you may google for self-referencing tables.
