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...
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.