subhalahha
New Member
- Joined
- Feb 21, 2015
- Messages
- 2
I am new to VBA and need your help. I have an Excel 2013 file (Name: Master Database) which have 3 sheets (Data 1, Data 2 & Data 3). I also have 5 different Excel files with same names (Data 1, Data 2, Data 3, Data 4 & Data 5) and all these files are saved in same folder (Folder path and name will differ every day).
I want a macro to perform the following tasks:
1. Browse the folder.
2. Copy details from Data 1, Data 2 and Data 3 files (without opening the files) and paste it in my Master Database file as per name of the sheets.
I want a macro to perform the following tasks:
1. Browse the folder.
2. Copy details from Data 1, Data 2 and Data 3 files (without opening the files) and paste it in my Master Database file as per name of the sheets.