copy multiple excel files in a workbook as sheets

bmeghana

New Member
Joined
Jul 28, 2009
Messages
2
Hi,
I need to copy individual excel files and create a single workbook with each file as a worksheet tab. the original files have only one worksheet each.
Is there any way to automate this process, since I need to do this on a weekly basis with around 20 files? If this has already been discussed, can anyone please guide me there. I wasn't able to find any threads which discussed combining files into separate worksheets within the same workbook.
Any help really appreciated!
Thank you,
Meg
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

bmeghana

New Member
Joined
Jul 28, 2009
Messages
2
Hi..thanks for the info. Is using that add-on the only way to do this? Since its not a Microsoft based software, i may need to go through validation processes to use any external software. Any other ideas really appreciated. thank you!
 

Watch MrExcel Video

Forum statistics

Threads
1,102,304
Messages
5,486,067
Members
407,530
Latest member
Shameem Khan

This Week's Hot Topics

Top