Hello.
I am not sure if you can help me. I just don't know...
I would love to know, how to make comparison chart to display two varying sets of data.
I have two workbooks.
One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.
Next
The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.
This is the hard part:
#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.
#2 How can I create a comparison chart to display two varying sets of data, both varying sets of data beginning with the zero values?
If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.
Thanks in advance
Cheers,
drive.google.com
drive.google.com
I am not sure if you can help me. I just don't know...
I would love to know, how to make comparison chart to display two varying sets of data.
I have two workbooks.
One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.
Next
The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.
This is the hard part:
#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.
#2 How can I create a comparison chart to display two varying sets of data, both varying sets of data beginning with the zero values?
If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.
Thanks in advance
Cheers,
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)