I have a work flow that contains a step that should extract specific data from Alpha.xlsx and update specif cells in Beta.xlsx. Both files contain the same unique ID in column A, to match with. I have created a data table of file Alpha. The output to be updated into file Beta.xlsx is located in column B in file Alpha.xlsx. The process should take the unique value of each row in column B in Alpha.xlsx and update column B in file Beta.xlsx based on the unique ID in column A. Since the list of unique IDs is long and will be updated frequently in both files I cannot work with specific cell references or named cells.
Unique ID Value
Values to be updated in Beta.xlsx:
In this case Apha xlsx. did not contain the Unique ID: 4534 so this row was not updated as the rest in Beta.xlsx.
Thanks in advance for any input!