VBA to copy data from multiple workbooks

Venkat1067

New Member
Joined
Apr 12, 2018
Messages
9
Hi VBA Community,

Need your Help..!!

I have more than 20 workbooks which contain data in multiple sheets. I need to copy only data from Sheet 2 from all workbooks to my Master Workbook.
In addition I need pop up to select the files path to copy data to Master Workbook.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,108,959
Messages
5,525,901
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top