Excel Macro for gathering data at one place

Rai - Dec 30, 2014 at 06:06 AM

I want to make a marco that copies the data from no. of workbooks which also contain no. of worksheets and gather all that data in one workbook in respective columns. For example I have 5 workbooks and each contain 10 worksheets. The macro should copy all the data from diff workbooks to specific worksheets given that respective worksheets contain same no of columns.