Forum Discussion
Combine data from multiple excel workbooks in a folder into one master file
I use Office 365 Hello, Please note that I made few changes to the criteria and the files that correspond to the new changes. I need help with VBA code that need to perform the below: There...
Hi. This solution is great and so intuitive. But there's one thing that needs to be considered and it will be golden.
Going forward, they added a new column in the Report file and combining the report files result in one of the columns showing incorrect content as the data shifted to the right with the additional column and created a mess.
Consequently, I have two data sets. I will add them to the data model so I can combine them.
Also, each column is a name range. I tried to select (or pick out) certain columns I want populated but it does not let me select more than one name range. Just to test, I added two name range columns with separate steps and it resulted in tripled or quadrupled line items.
What would be a solution here to resolve this?
Thanks again.
Going forward, they added a new column in the Report file and combining the report files result in one of the columns showing incorrect content as the data shifted to the right with the additional column and created a mess.
Consequently, I have two data sets. I will add them to the data model so I can combine them.
Also, each column is a name range. I tried to select (or pick out) certain columns I want populated but it does not let me select more than one name range. Just to test, I added two name range columns with separate steps and it resulted in tripled or quadrupled line items.
What would be a solution here to resolve this?
Thanks again.
alex_n Difficult to follow what you are trying to achieve. Can you share a file?
- They added a new column called Fee in reports 4 and 5.
How will the combining work if reports 3 and 4 have new column?
https://1drv.ms/f/s!Aqv4zBSFNKaymn_m8d9SM-0VmzlB?e=d5NNXl
Thanks,alex_n Will get back to you tomorrow, if not someone else jumps in.
I cannot find a way where I can populate multiple columns using the name ranges as opposed to populating the entire tab where the contents of the columns will be mixed up as new columns were added with reports 3 and 4. It only lets me populate one name range column at a time.
Here is the parameters list when I invoke custom function:
'Summary' is entire tab
'Contract' through 'Year' are name ranged columns. It is missing 'Overhead' name ranges that was added to report 4.