How to automatically extract data from an existing CHART, from one workbook "Example: GDP_Annual_Growth_Rate_%.xlm" to the CHART workbook "Example: PMI.xlm". Using VBA in excel.
Now, the worksheets data in each workbook is name after a country.
Example Below:
How can VBA extract data from worksheet #8: "Australia" in GDP_Annual_Growth_Rate_%.xlm workbook. To worksheet #2: "Australia" in PMI.xlm workbook Chart.
Note:
Thanks in advance
Cheer
PMI.xlsm
GDP_Annual_Growth_Rate_%.xlsm
Now, the worksheets data in each workbook is name after a country.
Example Below:
How can VBA extract data from worksheet #8: "Australia" in GDP_Annual_Growth_Rate_%.xlm workbook. To worksheet #2: "Australia" in PMI.xlm workbook Chart.
Note:
- GDP_Annual_Growth_Rate_%.xlm workbook, have 185 worksheet. Each named after a country.and
- PMI.xlm workbook, have 51 worksheet. Each named after a country
Thanks in advance
Cheer
PMI.xlsm
GDP_Annual_Growth_Rate_%.xlsm