Hello,
I need some help with excel. I have more than twenty workbooks, inside each workbook, the columns are exactly the same with different numbers. I want to merge all workbooks into one worksheet in one workbook . (usually, I just open every workbook, then copy and paste the content into the first workbook)
Anyone knows how to do it?
Thanks so much!!!!!!!!!!!!!!!!!!!!!
I need some help with excel. I have more than twenty workbooks, inside each workbook, the columns are exactly the same with different numbers. I want to merge all workbooks into one worksheet in one workbook . (usually, I just open every workbook, then copy and paste the content into the first workbook)
Anyone knows how to do it?
Thanks so much!!!!!!!!!!!!!!!!!!!!!