Hi
Each file has multiple columns in Sheet("Data1") with a different column name for each. The number of columns in each file can be different. There is one common column in each file named "Date". I want to combine the files by using the Date as the join column. Ideally this can be dynamic if the file names and column names are included in a list as not all columns from each file are required. In the Result file columns Orange & Green are excluded.
Thank you in advance.
Each file has multiple columns in Sheet("Data1") with a different column name for each. The number of columns in each file can be different. There is one common column in each file named "Date". I want to combine the files by using the Date as the join column. Ideally this can be dynamic if the file names and column names are included in a list as not all columns from each file are required. In the Result file columns Orange & Green are excluded.
Thank you in advance.