Hi all, I have been looking for a macro that could allow me to
1- read a CSV file that has a column with a series of id values, similar to this.

2- Get those values and, one by one, open all the CSV files in a certain folder then copy a value in a fixed cell for each one, in the same order in which those IDs were ordered in the "master" CSV.
The result would be a number n of CSV files that were previously present in a certain folder and that now have an ID value in a particular column.
Any idea how I could do it with a macro or within excel?
Thanks for any suggestions or ideas.
1- read a CSV file that has a column with a series of id values, similar to this.

2- Get those values and, one by one, open all the CSV files in a certain folder then copy a value in a fixed cell for each one, in the same order in which those IDs were ordered in the "master" CSV.
The result would be a number n of CSV files that were previously present in a certain folder and that now have an ID value in a particular column.
Any idea how I could do it with a macro or within excel?
Thanks for any suggestions or ideas.