hi Expert
I am trying to combine with more than 5 different workbooks into one master file and publish it to sharepoint list.
1. each workbook has single sheets
2. most of the column name are common in the workbooks but there are other files where we have additional column
3. create a macro which will read the file from the directory
4. add a column in master file which shows the source file name
folder with files:
sample of column name in each file:
desired output:
| desired output | | | | | | |
| ID | name | Dept ID | Dept | region | comments | value | Filename |
| 1 | ABC | | | east | | | Avp |
| 2 | cba | fin12 | finance | west | | | IMP |
| 3 | xyz | | hr | north | tbd | 100 | IV |
