Vithanalas
New Member
- Joined
- May 29, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
Am new to the vba coding. Here is the requirement to complete the project.
1. I have multiple XLSB files in same folder.
2. Need to get the data from the cells: (C6:C60) with the work sheet " Data" ( here I have number of workbooks available to get data)
3. I have to paste that above range data to my master file sheet "Working" with multiple ranges (i.e, I have defined) side by side.
4. Prepared the list of excel files in master file and I need to open same files and get data and paste into the master workbook side by side. ( i.e., name ranges are defined side by side columns in the Master workbook.
5. My concern is looping. (i.e., if my VBA coding is opened particular data file, as per list, that should be go to the master file as per defined range for the particular file, and again next file to be opened in the list and copy data and paste it into the next name range defined column in the Master work book file..and so on...)
Please help in this.
Am new to the vba coding. Here is the requirement to complete the project.
1. I have multiple XLSB files in same folder.
2. Need to get the data from the cells: (C6:C60) with the work sheet " Data" ( here I have number of workbooks available to get data)
3. I have to paste that above range data to my master file sheet "Working" with multiple ranges (i.e, I have defined) side by side.
4. Prepared the list of excel files in master file and I need to open same files and get data and paste into the master workbook side by side. ( i.e., name ranges are defined side by side columns in the Master workbook.
5. My concern is looping. (i.e., if my VBA coding is opened particular data file, as per list, that should be go to the master file as per defined range for the particular file, and again next file to be opened in the list and copy data and paste it into the next name range defined column in the Master work book file..and so on...)
Please help in this.