How to make comparison chart to display two varying

matrix · Jul 17, 2020

[FONT=&quot]Hello.[/FONT]

[FONT=&quot]I am not sure if you can help me. I just don't know...[/FONT]

[FONT=&quot]I would love to know, how to make comparison chart to display two varying sets of data.[/FONT]

[FONT=&quot]I have two workbooks.[/FONT]

[FONT=&quot]One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.[/FONT]

[FONT=&quot]Next[/FONT]

[FONT=&quot]The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.[/FONT]

[FONT=&quot]This is the hard part:[/FONT]

[FONT=&quot]#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.[/FONT]

[FONT=&quot]#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?[/FONT]

[FONT=&quot]If you think I sound crazy[/FONT]:dance::sad::dance:[FONT=&quot]. 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.[/FONT]

[FONT=&quot]Thanks in advance[/FONT]

[FONT=&quot]Cheers,

[/FONT]https://drive.google.com/file/d/1mmsL54lWBSVNsrP0INleJe-uW8U-2VVD/view?usp=sharing

https://drive.google.com/file/d/1JigNJKkY2IMGg4-aSXu0NnFnRRuvb6jx/view?usp=sharing
[FONT=&quot]
[/FONT]

How to make comparison chart to display two varying

matrix

New member