Hello excel world.
I am in your debt. I need your help if you are willing to help me... I am sorry for the inconvenience cause in the pass...
Please read my concerns:
#1 I have "2" workbooks name:
#3 In "GDP_Annual_Growth_Rate_%" workbook. I have "1" Navigation worksheet, "1" Master worksheet and "185 worksheet which is name after a country. Example Sheet #1 "Afghanistan"; Sheet #2 "Albania"; Sheet #3 "Algeria" and so on...
My problem here is this:
a) How can I create a chart using VBA to automatically get the data in each country worksheet from "Unemployment_Rate" and "GDP_Annual_Growth_Rate_%" workbook?
b) How can I get data from column "B" (which is the date column) and column "E" (which is the value column) in all country worksheet in Unemployment_Rate" workbook? And
c) How can I get data from column "B"(which is the date column) and column "E" (which is the value column) in all country worksheet in "GDP_Annual_Growth_Rate_%" workbook? See example photo of how the chart is displayed:
My Other Problem:
How can I paste each chart into each country worksheet in "Unemployment_Rate" workbook automatically using a VBA?
___________________________________________________________________________________________________________________________________________________________________________________________________________
With lack of knowledge for excel. I don't know if this request can be accomplish. To me it sounds difficult. I am opened for a better outcome, once available.
Below you can view other supported images and excel files that relates with this project.
How can you all help me?
Thanks in advance
Corrie
drive.google.com
drive.google.com
I am in your debt. I need your help if you are willing to help me... I am sorry for the inconvenience cause in the pass...
Please read my concerns:
#1 I have "2" workbooks name:
- Unemployment_Rate
- GDP_Annual_Growth_Rate_%
#3 In "GDP_Annual_Growth_Rate_%" workbook. I have "1" Navigation worksheet, "1" Master worksheet and "185 worksheet which is name after a country. Example Sheet #1 "Afghanistan"; Sheet #2 "Albania"; Sheet #3 "Algeria" and so on...
My problem here is this:
a) How can I create a chart using VBA to automatically get the data in each country worksheet from "Unemployment_Rate" and "GDP_Annual_Growth_Rate_%" workbook?
b) How can I get data from column "B" (which is the date column) and column "E" (which is the value column) in all country worksheet in Unemployment_Rate" workbook? And
c) How can I get data from column "B"(which is the date column) and column "E" (which is the value column) in all country worksheet in "GDP_Annual_Growth_Rate_%" workbook? See example photo of how the chart is displayed:
My Other Problem:
How can I paste each chart into each country worksheet in "Unemployment_Rate" workbook automatically using a VBA?
___________________________________________________________________________________________________________________________________________________________________________________________________________
With lack of knowledge for excel. I don't know if this request can be accomplish. To me it sounds difficult. I am opened for a better outcome, once available.
Below you can view other supported images and excel files that relates with this project.
How can you all help me?
Thanks in advance
Corrie
Unemployment_Rate.xlsm
![drive.google.com](/board/proxy.php?image=https%3A%2F%2Fssl.gstatic.com%2Fimages%2Fbranding%2Fproduct%2F1x%2Fdrive_2020q4_32dp.png&hash=a1fd16a7baece8a69609b4d04ba57b62&return_error=1)
GDP_Annual_Growth_Rate_%.xlsm
![drive.google.com](/board/proxy.php?image=https%3A%2F%2Fssl.gstatic.com%2Fimages%2Fbranding%2Fproduct%2F1x%2Fdrive_2020q4_32dp.png&hash=a1fd16a7baece8a69609b4d04ba57b62&return_error=1)