Forum Discussion
How to update unlinked columns according to content of a column linked to a external source file?
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.
You'd have to create a separate lookup range, with the numbers 1 to n in a column, and the corresponding data intended for columns E, F, ... next to that column.
You can then use VLOOKUP or XLOOKUP to place the correct data next to columns A to D.
