Seeking advice from advance excel gurus on this forum

[Corried]

Hello excel world.


I am seeking advice from advance excel gurus on this forum.


Here's the concern.


I found this code with its photo below searching online:


string strCountry = US; // Set country ( sheet name )
plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>]; // Plot into graph template LINE12 that is pre-created.
plotxy iy:=[Book2]strCountry$!(1,2) plot:=200 ogl:=1;
layer -g; //Group plots

My problem here is this:


#1 How can I modify this code to automatically detect, the same worksheet names on each workbook. Example: Workbook (A) worksheet (United States) and workbook (B) worksheet (United States)


Now
Workbook (A) have 181 worksheets. (Each worksheet represent a country) And
Workbook (B) have 185 worksheets. (Each worksheet represent a country) Next.


#2 How can I modify the code to create a line and column chart automatically? Placing dates on the X axis and values from both workbooks using their prospective worksheets on both sides of the Y axis, beginning from the zero value.


How can this be done automatically, filling each worksheet with a chart, while extracting data from each workbook?

 

[Corried]

Thanks for your explanation. Gee. I really is embarrass now??. I was lost all the time. I did not know that the code is related to an app. I am novice in excel. I don't know what to say or do from here...

What would you recommend me to do from here?

I am seeking for a code in "excel" to:

" #1 Automatically detect, the same worksheet names on two different workbooks. Example: Workbook (A) worksheet (United States) and workbook (B) worksheet (United States)" Understanding that.

Workbook (A) have 181 worksheets. (Each worksheet represent a country) And
Workbook (B) have 185 worksheets. (Each worksheet represent a country) Then.

"#2 How to create a line and column chart automatically? Placing dates on the X axis and values from both workbooks using their prospective worksheets on both sides of the Y axis, beginning from the zero value.

How can this be done using Macros?

How can this be done automatically, filling each worksheet with a chart, while extracting data from each workbook? "

 

[Fluff]

As I know nothing about charts (I've never used them) I cannot help.

 

[Corried]

As I know nothing about charts (I've never used them) I cannot help.

Thanks for your patience with me. It seems like you are a nice person.

How can you point me to the right direction? or What person/s you recommend me to talk to?

How do you want me to move forward?

Thanks in advance.

 

[Fluff]

I would suggest you start a new thread explaining what you want & I will close this one.