Hi,
I am hoping someone can help me with a macro that would copy all data from multiple workbooks and paste on top of each other. The only type of data consolidation macros I've come across are ones that import entire sheets into one workbook.
These workbooks are all in the same format, dynamic in range in terms of the number of rows, and have only 1 sheet.
I'd like the macro to prompt the user to select all the files that need to be copied (clicking a file and holding down Ctrl to select additional files), which would then be pasted into a blank workbook starting in row 2. These files have data in rows A:K.
I appreciate any help with this.
I am hoping someone can help me with a macro that would copy all data from multiple workbooks and paste on top of each other. The only type of data consolidation macros I've come across are ones that import entire sheets into one workbook.
These workbooks are all in the same format, dynamic in range in terms of the number of rows, and have only 1 sheet.
I'd like the macro to prompt the user to select all the files that need to be copied (clicking a file and holding down Ctrl to select additional files), which would then be pasted into a blank workbook starting in row 2. These files have data in rows A:K.
I appreciate any help with this.