I have a file named as "consolidator", in which data is being collected from multiple files (without opening them)(in this example it pulls data from files B1 and B2; placed in the same folder where consolidator file is placed. This tool works fine when the number of columns to be pulled is less than 20, but when i make changes in the code to pull more than 20 columns of data, then it gives run-time error '1004'.
This error is coming from the line
code line which pulls 20 columns of data without error is
Code line which gives error when i try to pull 100 columns of data
I have attached all the three files for easy understanding. In the attached file code is for pulling 20 columns of data. Please suggest what changes i should make in the code to pull 100 columns of data present in files B1 and B2.