Forum Discussion
Poubel
Feb 15, 2023Copper Contributor
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...
HansVogelaar
Feb 15, 2023MVP
Do the columns from E on have an explicit relationship with columns A to D - do they have a value in common, for example?
- PoubelFeb 16, 2023Copper Contributor
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.
- HansVogelaarFeb 16, 2023MVP
I don't see how that would be possible if there is no link between the two sets of data.
- PoubelFeb 16, 2023Copper ContributorColumn 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?